OssieMac,
I do not know how to insert a macro or run it. Instructions would be grand!
I have Excell 2003.
Your first response hit the nail on the head. That is exactly what I am
trying to do. Any help would be greatly appreciated.

"OssieMac" wrote:

Afterthought. Do you know how to insert a macro and run it or do I need to
provide instructions.

Also what version of XL do you have?

Regards,

OssieMac

"kimbafred" wrote:

For example

Column 1 row1: Mr. Jerry Brown
Column 1 row2: 123 Somewhere St.
Column 1 row3: Somewhere, CA 99999

I need to get the address line (Column 1 row2:) and the City, State Zip line
(Column 1 row3:) to go to different columns i.e.:
(Column 1row2:) = (Column 2 row2:) and (Column 1 row3:) = (Column 3 row3:)
I don't even know if this is possible.



"OssieMac" wrote:

I don't understand what you want to do. You say the data is in one column but
different rows and you want to get the address and citystatezip into
different rows. Can you post a sample of the existing data and a sample of
how you want them to look.

Regards,

OssieMac

"kimbafred" wrote:

I have a file that came out of a program where the Name, address,
citystatezip are in the same column but different rows. I have some 1400
names in this column and I need to get the address and citystatezip in
different rows so I can do a mail merge