Edit many cells at once to add a charater to existing data?
Helper column ="'"&A1 and copy down. The copy this column, & Edit/ Paste
Special/ Values over the original data and delete the helper column.
--
David Biddulph
"ABTurner" wrote in message
...
I have a column of data and I need to add an apostrophe to the beginning of
all the cells without changing the remaining content. How can I do this?
I
know how to do this for individual cells, but I would like to do it to all
cells at once.
|