View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Cal Cal is offline
external usenet poster
 
Posts: 7
Default How do I remove "special characters" from cell data?

i exported data from another application. Cells now contain some unusual
line return characters (some appear as boxes, others as really dark |
characters). My version of Excel 2003 does not have the ability to find and
replace these characters. Any suggestions on how I can remove these? My
ultimate goal is to parse the data using TEXT TO COLUMNS.
Thanks.
Cal