Text to columns

[reno]

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

[Ron Coderre]

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
>