Select the range
Edit|replace
what: spacebar, then alt-0160
with: (leave blank)
replace all

Then use data|text to columns using alt-0160 as the delimiter.

reno wrote:

you're right on the chr.
it shows
Dec 160 160 032 160
between the street addr and start of city.
suggestions?
thx

"reno" wrote:

I have downloaded 600 name address list from web. i'm tryin to parse the
address. an address example is show he
2449 63rd St Vinton
503 W 6th St Vinton
5378 - 29th Avenue Vinton
525 C Ave. W Norway
2414 76 St Watkins
There seem to be 5 blank spaces between the last of the physical addr and
the start of the city. Find/Replace does not seem to work, the text/col
doesn't recognize the 5 spaces.

Any ideas?
Thx

--

Dave Peterson