Excel creates a text entry from the apostrophe. That's why you can't find
it. Use Text to Columns instead.

Highlight the column.
DataText to Columns
NextNextFinish

Regards,
Fred.

"Soth" wrote in message
...
Hi,

It says Excel can not find this ' to replace. I'm not sure why.

Soth

"Eduardo" wrote:

HI,
highlight the column, CTRL H, value to find enter ' replace with leave
blank

hope this helps

"Soth" wrote:


Hi-

In a cell consist of this number '24110100, I did try copy and paste
special
trying to get rid of this apostrophe " ' " in front of number and I'm
not
able to do so. The other way is to delete it, but I have thousands of
numbers. Is there a better way to get rid of this apostrophe ' sign?

Thanks,
Soth