merging of cells
 

Can anyone tell me how I can take the information from four cells in one row
and four columns and stack it into one cell? I have 300 rows I need to do
this with. You will find a example below:

From: SUPPLIER CONTACT TELEPHONE FAX (COLUMN HEADER)
WD RalpH 734-7990 838-8787 (CELLS)

TO: SUPPLIER (COLUMN HEADER)
WD (ONE CELL)
RalpH
734-7990
838-8787

Thanks for the help on a tall question.

merging of cells
 

Say your data was in Columns A to D.
Try this in say E2:

=A2&CHAR(10)&B2&CHAR(10)&C2&CHAR(10)&D2

And copy down as needed.

Format Column E to "Wrap Text" under:

<Format <Cells <Alignment tab.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"He cries for help" wrote in
message ...
Can anyone tell me how I can take the information from four cells in one
row
and four columns and stack it into one cell? I have 300 rows I need to do
this with. You will find a example below:

From: SUPPLIER CONTACT TELEPHONE FAX (COLUMN HEADER)
WD RalpH 734-7990 838-8787 (CELLS)

TO: SUPPLIER (COLUMN HEADER)
WD (ONE CELL)
RalpH
734-7990
838-8787

Thanks for the help on a tall question.

merging of cells
 

This worked great thanks

"He cries for help" wrote:

Can anyone tell me how I can take the information from four cells in one row
and four columns and stack it into one cell? I have 300 rows I need to do
this with. You will find a example below:

From: SUPPLIER CONTACT TELEPHONE FAX (COLUMN HEADER)
WD RalpH 734-7990 838-8787 (CELLS)

TO: SUPPLIER (COLUMN HEADER)
WD (ONE CELL)
RalpH
734-7990
838-8787

Thanks for the help on a tall question.

merging of cells
 

You're welcome, and thanks for the feed-back.
--

Regards,

RD
-----------------------------------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit !
-----------------------------------------------------------------------------------------------

"He cries for help" wrote in
message ...
This worked great thanks

"He cries for help" wrote:

Can anyone tell me how I can take the information from four cells in one
row
and four columns and stack it into one cell? I have 300 rows I need to do
this with. You will find a example below:

From: SUPPLIER CONTACT TELEPHONE FAX (COLUMN HEADER)
WD RalpH 734-7990 838-8787 (CELLS)

TO: SUPPLIER (COLUMN HEADER)
WD (ONE CELL)
RalpH
734-7990
838-8787

Thanks for the help on a tall question.