You're not going to find a short answer. It all depends on how different
your addresses look. What if you sometimes have a middle initial, or a
two-word first name, or a Jr.? Are all your addresses in the US? Do any of
them have the zip+4? Do your street addresses include commas because of
apartment numbers, etc.? The solution that you're given will depend on how
well you want it to react to all the possibilities in your data.
Having said that, I would suggest you do the following:
In Word, get all your addresses seperated by a blank line so they look like:
Joe Smith
123 Main Street
Anywhere, USA 12345
Joe Smith
123 Main Street
Anywhere, USA 12345
1. Change all double line feeds to a tilde. (Edit - Replace - change ^p^p
to ~)
2. Change all remaining line feeds to a tab (Edit - Replace - change ^p to
^t)
3. Change all ~ back to a single line feed (Edit - Replace - change ~ to ^p)
Now you should have the following:
Joe Smith 123 Main Street Anywhere, USA 12345
Joe Smith 123 Main Street Anywhere, USA 12345
Copy and paste that into Excel. This'll give you one address per row, and
you can use LEFT, RIGHT, and MID, functions to further parse your results.
Was that of any help?
ST said:
I have a Word document that is formatted as address labels. I would like
to take the data and insert it in columns of a spreadsheet. For example
Joe Smith
123 Main Street
Anywhere, USA 12345
Would then get pasted into the following columns: first name, last name,
street address, city, state, zip code. Can this be accomplished? Thanks
for your help.
