Delete apostrophe
 

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?

--
Message posted via http://www.officekb.com

Hi
see your other post

--
Regards
Frank Kabel
Frankfurt, Germany

"Susana Conklin via OfficeKB.com" schrieb im
Newsbeitrag ...
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?

--
Message posted via http://www.officekb.com

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

"Susana Conklin via OfficeKB.com" wrote:

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?

--
Message posted via http://www.officekb.com