software

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

Since you got them from the Web, maybe they're not spaces--they could be those
troublesome HTML non-breaking spaces (x160).

Chip Pearson has a very nice addin that will help determine what that
character(s) is:
www.cpearson.com/excel/CellView.htm

If those 5 quot;spacesquot; are the only char(160)'s in the cell, you may be able to
just:

Select the range
data|text to columns
delimited by other
hit and hold the alt key while typing 0160 using the numeric keypad
and check that box to quot;treat consecutive delimiters as onequot;

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

--

Dave Peterson

you're right on the chr.
it shows
Dec 160 160 032 160
between the street addr and start of city.
suggestions?
thxquot;renoquot; wrote:

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

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:
gt;
gt; you're right on the chr.
gt; it shows
gt; Dec 160 160 032 160
gt; between the street addr and start of city.
gt; suggestions?
gt; thx
gt;
gt; quot;renoquot; wrote:
gt;
gt; gt; I have downloaded 600 name address list from web. i'm tryin to parse the
gt; gt; address. an address example is show he
gt; gt; 2449 63rd St Vinton
gt; gt; 503 W 6th St Vinton
gt; gt; 5378 - 29th Avenue Vinton
gt; gt; 525 C Ave. W Norway
gt; gt; 2414 76 St Watkins
gt; gt; There seem to be 5 blank spaces between the last of the physical addr and
gt; gt; the start of the city. Find/Replace does not seem to work, the text/col
gt; gt; doesn't recognize the 5 spaces.
gt; gt;
gt; gt; Any ideas?
gt; gt; Thx

--

Dave Peterson


Dave you're the Man, that worked!

Thanks!!
quot;renoquot; wrote:

gt; you're right on the chr.
gt; it shows
gt; Dec 160 160 032 160
gt; between the street addr and start of city.
gt; suggestions?
gt; thx
gt;
gt;
gt; quot;renoquot; wrote:
gt;
gt; gt; I have downloaded 600 name address list from web. i'm tryin to parse the
gt; gt; address. an address example is show he
gt; gt; 2449 63rd St Vinton
gt; gt; 503 W 6th St Vinton
gt; gt; 5378 - 29th Avenue Vinton
gt; gt; 525 C Ave. W Norway
gt; gt; 2414 76 St Watkins
gt; gt; There seem to be 5 blank spaces between the last of the physical addr and
gt; gt; the start of the city. Find/Replace does not seem to work, the text/col
gt; gt; doesn't recognize the 5 spaces.
gt; gt;
gt; gt; Any ideas?
gt; gt; Thx