Excel 2003 - Text Import Wizard problem.

L

LEXCERM

Hi All,

I have used the Text Import Wizard in all versions of Excel from 9
onwards without any problem.

Since upgrading to Excel 2003, that is where the fun starts. For som
reason when opening a .txt or .rpt file, the preview seems to ad
little squares at the end of each line. When scrolling down th
preview, then back up, the data then jumbles itself up. I presum
these squares are printing characters of some sort but how can I ge
rid of them? It is causing all sorts of issues with pre-set macro
that I have set-up from previous versions of Excel.

Regards,
PAUL
 
G

Gord Dibben

Paul

Most likely these are line feeds.

Are several lines of data in each cell with a square at end of each line? Or
one line per cell with a square at the end?

You can turn on Word-wrap to not see them or get rid of them completly through
Edit>Replace

what: Hold ALT key and type 0010(use NumPad for this)
with: nothing

OR use Data>Text to Columns>Delimited>Other ALT + 0010

Finish.

Other line-feed character is 0013 if 0010 not working.

Gord Dibben Excel MVP
 
Top