OR
Just select the column with the leading, hidden apostrophes, and simply open
and close "TextToColumns".

Select the column.
<Data <TextToColumns <Finish
And you're done!
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


"tjtjjtjt" wrote in message
...
When I tried REplace to try and answer this question, Excel didn't find the
Lead '.
If you are having the same issue, brokenmonkey, you might try:
One way to fix a column like this:
Create an extra column.
Put this formula in it: =LEFT(A1,LEN(A1))
Copy it down.
Then Copy all the cells and Edit | Paste Special, Values.
Last Delete the original column.

tj

"Alan" wrote:

Try Tools Edit Replace ' Replace With leave bank Replace All
Regards,
"brokenmonkey" wrote in message
...
How do I get rid of all the hidden apostrophes poplating every cell with
data, text and numeric?