How to delete a ' from front of data
"myasmana" wrote:
I have a spreadsheet that needs to be converted here at work. The problem is
that in a couple of columns I have data with (') in front of each word such as : 'South Dakota 'Illinois 'Nebraska
You do not see the (') until you are in the cell, is there a global way to
delete this?
There are way to many to try and fix manually. Any help would be appreciated.
Thanks,
Barb
|