Dave O

Thanks for your response. Here is how the data is input.

Name of property: XYZ (location cell A4)
Property address: 123 Main Street (location cell A5)
City: Anytown (location cell A6)
Cross Street: First Street (location cell a7)

There are no lines that seperate the data. I need to just extract out
the information after the :

The "Name of property:" would become a header on the excel spreadsheet
in column A. The "Property address" would become a header on the excel
spreadsheet in column B - etc. etc. etc.

I could then sort the database after conversion out of the row format
into the columnar format. For example by city or street etc.

I would input the header info into the spreadsheet so I do not really
need to save this as I could do a find and replace it and just get rid
of it that way.

Let me know if this makes sense.

Thanks for all your help.

Damion


--
zero760
------------------------------------------------------------------------
zero760's Profile: http://www.excelforum.com/member.php...o&userid=26800
View this thread: http://www.excelforum.com/showthread...hreadid=400545