View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
reno
 
Posts: n/a
Default Find/Replace or VBA

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