Apostrophes in Cell
A simple solution to a simple problem.
Thank You that worked great, just what I was looking for.
"Lori" wrote:
Try Data Text to columns Finish on the column.
On Feb 21, 5:40 pm, Megadrone
wrote:
I create a formula in a cell, I take the result (a number) and copy (values
to get rid of the formula) it into a cell to the left. When done there is an
apostrophe at the beginning of the number.
How can I get rid of this apostrophe with find/replace command. I have tried
everything, it just comes back teling me it can not find a data...
PS.
I'm doing this with about 33,000 lines of data.
|