| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy from a Cell to a text box. | Excel Worksheet Functions | |||
| convert numbers to text | Excel Discussion (Misc queries) | |||
| Macro to convert text to date | Excel Worksheet Functions | |||
| Text to Columns / Importing Data | Excel Discussion (Misc queries) | |||
| How do I convert text to columns when there is a carriage return? | Excel Worksheet Functions | |||
Threaded Mode
