Convert address block into delimited rows?
 

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.

Convert address block into delimited rows?
 

All example data is in one cell?

Try DataText to ColumnsDelimited byOther

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

On Fri, 24 Jul 2009 08:28:01 -0700, Mr B
wrote:

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.