Convert address block into delimited rows?

  • Thread starter Thread starter Mr B
  • Start date Start date
M

Mr B

Not sure if this should go in Word or Excel but here's the deal...

I have a document in Word that contains a bunch of address in the format of

Name
Address
City, State, Zip
Telephone
Website

After each internal line is a line break and after the last entry is a
paragraph return if that makes it any easier.


I want to get them into Excel in the format of:

Name, Address, City, State, Zip, Telephone, etc

Anyone know of an automated way to do that? Maybe some sort of import or
export or something that I can do? Just don't want to have to do it all
manually.

Thought I could do a find and replace and turn the line breaks into commas
or something maybe but don't kow how to do a find on a special character like
that.

Also, not all addresses have all the fields. Some have websites, some don't.
 
All example data is in one cell?

Try Data>Text to Columns>Delimited by>Other

Hit CTRL + j for line breaks.

Finish to break into columns.

You will then select City, State, Zip column and split that into 3 by using
delimited by comma.

Don't forget to insert a couple of blank columns to the right first.


Gord Dibben MS Excel MVP
 
Back
Top