View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Nick H
 
Posts: n/a
Default How do I delete hidden character in Excel?

Isa,

You could try using the CLEAN worksheet function. e.g. if your data is
on Sheet1 create a new sheet and in Cell A1 of that sheet enter
=CLEAN('Sheet1'!A1) and drag-copy that formula to an area the same size
as the data on Sheet1.

Having done that you may want to copy the data on your new sheet and
pastespecial the values to get rid of the formulas.

HTH

Nick.