View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Cindi Cindi is offline
external usenet poster
 
Posts: 22
Default 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.