View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave O
 
Posts: n/a
Default CSV file with 13space characters in blank cells

How about a Find and Replace? Click Edit Replace; enter thirteen
hard spaces in the FIND box and leave the REPLACE WITH box empty.

Sometimes these cells come across with a leading apostrophe- let us
know if yours does too.