Could be the squares are linefeeds......which show as little squares until
you set the cells to wrap text.

If you want to get rid of them, select all cells and EditReplace

What: CTRL + j

With: whatever you like.....nothing or space or???

Replace all.

Or if you want to split the data at the linefeeds use DataText to
columnsDelimited byOther.........Alt + 0010


Gord Dibben MS Excel MVP

On Thu, 30 Apr 2009 11:20:16 -0700, MDG
wrote:

I have an Excel document that includes a list of e-mail addresses as well as
other data. This was saved as a .txt file. When reopened, the double quotes
that were inserted by Notepad are apparently not recognized by Excel and so
show up as squares. Not sure if Notepad separates columns using the double
quotes, but it seems that way and so I don't have much control over it. Any
thoughts about fixing this OR a way to resave so that the quotes don't show
up to begin with??