convert text to columns
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.
|