problem import text file

hi,
when i try to import text file to excel, i find that there are lots of
=E2=96=A1 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


"Lynn" <moley_cruz@yahoo.com.au> wrote in message news:1128239809.490793.207970@g44g2000cwa.googlegroups.com...
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