Delete apostrophe

[Susana Conklin via OfficeKB.com]

Hi,

I have a database with over 14400 lines of info that I need to delete the apostrophe before the value, to make it a value, how do I do this?

 

[Frank Kabel]

Hi
see your other post

--
Regards
Frank Kabel
Frankfurt, Germany

Hi,

I have a database with over 14400 lines of info that I need to delete

the apostrophe before the value, to make it a value, how do I do this?

 

[Martin P]

You could try =VALUE(celladdress) followed by Paste Special.