Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Text to columns
I have downloaded address list from web, i've been able to parse everything
except the physical addr and the city. the city seems to be separated by two blank spaces as shown. It's not fixed length and the space delimiter does not seem to work. 1911 - 290th Street Greenfield 6212 N 131st St Omaha 2773 290th St Orient 2956 North View Road Dorchester Any ideas? Thanks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Text to columns
There may be HTML non-breaking spaces in the text.
Try this: On the Step 2 of the Text-to-Columns Check: Other in the character box: hold down the [alt] key, type 0160, release the [alt] key Continue with the Text-to-Columns Does that help? *********** Regards, Ron XL2002, WinXP-Pro "reno" wrote: I have downloaded address list from web, i've been able to parse everything except the physical addr and the city. the city seems to be separated by two blank spaces as shown. It's not fixed length and the space delimiter does not seem to work. 1911 - 290th Street Greenfield 6212 N 131st St Omaha 2773 290th St Orient 2956 North View Road Dorchester Any ideas? Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I unwrap text to columns? | Excel Discussion (Misc queries) | |||
Text to columns - one way street? | Excel Discussion (Misc queries) | |||
How do I convert from text to columns automatically on import? | Excel Discussion (Misc queries) | |||
comparing columns of text (cross-searching) | Excel Discussion (Misc queries) | |||
Text to columns | Excel Discussion (Misc queries) |