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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Alt codes 4
Importing Text Files Into Access 1
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Differences Between Two Spreadsheets ? 1
ReImport text data and keep existing formatting 1
Special text character problem 1
Import files into access 1
Data Connection with Text Import Problem 8

Back
Top