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.