problem import text file

  • Thread starter Thread starter Lynn
  • Start date Start date
L

Lynn

hi,
when i try to import text file to excel, i find that there are lots of
â–¡ symbols on my spreadsheet.
any idea how to get raid of them?
thanks
 
Hi Lynn

CHAR(10) is inserted when you use Alt-Enter to force a line wrap. It is not
"seen" in the cell it is entered in but will appear as a box in cells that reference it.

You can use this macro to clean your data
http://www.mvps.org/dmcritchie/excel/join.htm#trimall


--
Regards Ron de Bruin
http://www.rondebruin.nl


hi,
when i try to import text file to excel, i find that there are lots of
? symbols on my spreadsheet.
any idea how to get raid of them?
thanks
 
Back
Top