merging of cells

[He cries for help]

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.

 

[Ragdyer]

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.

 

[He cries for help]

This worked great thanks

 

[RagDyeR]

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