Not sure why Gord thinks his clever formula won't work with your data. I
tested it and it works well. It places City, State, Zip in one cell but using
Text To Columns will separate them.

--
Regards,

OssieMac


"Gord Dibben" wrote:

oops.

Saw your follow-up post to Ossiemac with the re-configuration you wanted.

Disregard my replies.


Gord

On Sat, 29 Mar 2008 11:37:24 -0700, Gord Dibben <gorddibbATshawDOTca wrote:

Read my reply.

You don't need macros.

Gord Dibben

On Sat, 29 Mar 2008 10:59:00 -0700, help please
wrote:

OssieMac I do not know how to do Macro

"OssieMac" wrote:

Need to fully understand your question. Does your data look like this all in
one column:-

Name
Street
City
State
Zip
Name
Street
City
State
Zip
and then repeated that way down the column? If it does, then I have a macro
that will rearrange it with column headers so that the names address etc are
set out across the worksheet like this:-

Name Street City State Zip

However, depending on the number of lines per name and address etc, it might
require a little editing. If you want it, then please post a sample of your
data. (Not real data that will identify anyone; use ficticuous names and
addresses.)

Also, if you want it, do you require any instructions to copy the macro in
and run it?


--
Regards,

OssieMac


"help please" wrote:

how do I change the lay out of an excel spread sheet, I have name address
city state and zip in column A all the way down, in lines of 3 about 900
addressess. I want to change them to the top of the page across, with
name-street-city-state-zip. I cant seem to get it to do what I want, any help
would be greatful.