View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
John C[_3_] John C[_3_] is offline
external usenet poster
 
Posts: 1
Default Remove hidden symbols in cells on excel?

We recieved large spreadsheet made up of part numbers, descriptions and
prices from our vendor. The cells have a hidden character and a space before
the cell contents. This must be removed to allow loading into our inventory
program. Is there a way to do this without clicking each sell and
backspacing it out?