View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
myasmana myasmana is offline
external usenet poster
 
Posts: 4
Default How to delete a ' from front of data

I have a spreadsheet that needs to be converted here at work. The problem is
that in a couple of columns 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