Dave you're the Man, that worked!

Thanks!!
"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