ExcelBanter - Text to columns

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Text to columns (https://www.excelbanter.com/excel-discussion-misc-queries/81957-text-columns.html)

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

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