Some detective work is required:

1. copy a typical item into an unused cell, say Z100
2. using the fomula bar, remove all characters except for a single small
square
3. In Z101 enter:
=CODE(Z1)

Once we know the code, we can change it into something Text to Columns can
use.
--
Gary''s Student - gsnu200779


"Nigel" wrote:

I have exported a table from MS Access to Excel to be able to use it as a
mailing list. When I try to convert text to columns I am unable to enter the
text delimiter as it is some sort of white square, well in fact there are two
squares together. Can any one help?
I've pasted a sample here but it shows without the squares and the text has
wrapped.

"Beech House
Witham Park
Waterside South"