Text to columns

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Find/Replace or VBA 4
Find/replace 5
Text to Columns Question 3
How do I manipulate a string to collect the address from it? 1
1 Excel row to 3 Access Table rows (formatted). 2
text to columns 8
Outlook email text to Excel - I'm so close! 6
Search text string for ssn and copy to new column 8

Back
Top