At 14:46 17/12/2009 +0200, Dotan Cohen wrote:
I have a spreadsheet with 1375 rows. One of the columns is a time column, with the format 'hh:mm:ss. Note the leading ' sign. In order to sum this column, I need to remove this character. However, the search and replace dialogue [does] not recognize this character.
If Find doesn't find the leading apostrophe, it may have been entered to force the input to be interpreted as text instead of as a time. In that case, the apostrophe will not actually appear in the cell, but be visible only in the input line when a cell is selected.
How can I remove them all easily?
If the problem is as I describe, you can simply use the TIMEVALUE() function. This function takes a text string and interprets it as a time value. You will need to format the result cells suitably as time values in order to see the values correctly, of course.
Another possibility is that you have a real apostrophe in your cell, but you are searching for a plain apostrophe whereas your data contains smart single quotes - or vice versa.
I trust this helps. Brian Barker --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
