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.