On Thu, Dec 17, 2009 at 7:46 AM, Dotan Cohen <[email protected]> wrote: > I have a spreadsheet with 1375 rows. One of the colums 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 s not recognize this character. How can I > remove them all easily?
WAG - use text to columns, fixed width and put the leading ' in it's own column. Dirty hack, but it works. Alternate - turn on 'use regular expressions in find-replace' and then you will be able to match that ' mark. It's off be default so as not to confuse people when $ isn't a dollar sign anymore :-) Brian --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
