If you have paste space you can remove lead apostrophes nearly
instantaneously.

For example, enter:
'=1+2 in ALL the cells in column A
select the column and copy

Then select the top cell in an un-used column (say column B) and:

Edit PasteSpecial values

You will see that column B replicates the contents of column A except all
the leading apostrophes are gone. If desired, you can copy back onto column
A.


This technique is effective if you have large blocks of apostrophic cells
that can be copy / pasted in this fashion.
--
Gary''s Student - gsnu200751


"David Mueller" wrote:

I used some code I found in the newsgroup to remove the leading, hidden
apostrophe that identifies cell contents as a string data type -- but it's
too slow.

Is there a faster method than the "FOR EACH ... {remove prefix character}
... NEXT" I'm using?

A common scenario for me is 10 worksheets, each with 200,000 cells of data
each. In addition, there is one column on each tab from which I do NOT want
to remove the prefix character.

I'm not sure search & replace will work for me because I have legit
apostrophes in my data.

Thanks in advance.
David