I tried that. I can't right-click to paste, but tried control-v to paste it
in the box. Didn't work. I can't even copy it from one cell to another in
the worksheet. Any other ideas? Thank you.

"Niek Otten" wrote:

Copy that one "square" character and paste it into the DelimiterOther box in the Text to Columns dialog


--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Cindi" wrote in message ...
|I downloaded data as CSV, but the addresses came over to excel with "little
| squares" at the end of each line, not a comma, so ended up in one cell. I
| have tried to split using the convert text to column wizard but no luck. Is
| there a way to key that "square" in the "Other" option of the deliminiator
| choices? Is there a better way to split the addresses? The addresses are
| not fixed length so can not use that option either. Using excel 2003. Thank
| you.