How can I delete the apostrophe in the cell

[msnews.microsoft.com]

I received the data in Excel that in som cells they put ' (apostrophe) in
front of text or number. How can I remove this apostrophe.

Mass removing though. Seems that the find/replacing doesn't work.


Thanks,

 

[Per Jessen]

Hi

Enter 1 in an unused cell, and copy it. Select cells with your data goto
Edit > PasteSpecial > Select "Multiply" > Ok

Hopes this helps.

 

[Bill Kuunders]

One way..........

Type 1 in a blank cell , copy it,

Select the whole range,

Edit->Paste Special->check Multiply->OK.

You will get 0's in any blank cells.
You could do a find and replace on them afterwards.

 

[Dana DeLouis]

Seems that the find/replacing doesn't work.

Hi. You may find this interesting...

XL2000: Can't Use Find/Replace on Text with Leading Apostrophe
http://support.microsoft.com/kb/214285

= = =
Dana DeLouis

 

[lakmerocks]

I received the data in Excel that in som cells they put ' (apostrophe) in front of text or number. How can I remove this apostrophe.Mass removing though. Seems that the find/replacing doesn't work.Thanks,

excellen! enter 1 paste special -multiply - it worked! Gr8! thnx