Dotan Cohen 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?
Thanks in advance.
Your date time is a text column actually and all the problems you
describe on this list indicate that you are in desparate need of a
database with distinct field types and input forms with specialized form
controls for the field types.
The ' is not part of the text value. It prevents automatic conversion
from text to number (assuming that you really want text since you
imported or entered text).
Find/Replace can re-enter all the values semi-automatically
Options: "Regular expression" and "Current selection only"
Search .+ [a dot and a plus]
Replace with: &
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
