Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Merging cells | New Users to Excel | |||
Merging cells | Excel Discussion (Misc queries) | |||
Merging Cells | New Users to Excel | |||
Merging Cells | Excel Discussion (Misc queries) | |||
Merging Cells | Excel Worksheet Functions |