| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Merge 3 cells in one
Have a work sheet 1500 name addresses phone # email address and company names
all in one cell. the first and last names were easy now Im having prob with email and company names company names are in 3 cells like long/&/Foster/ dont know how to combine I get getting confused with the formulas there are 1500 cells need to be combined and phone # and email address Thanks Gary |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Merge 3 cells in one
use the ampersand to concatenate
For example: In f1 you could have: =A1& " " & B1 & " " & C1 If you had in A1 Long and in B1 Foster and c1 Something else you would get: Long Foster Something Else in F1. -- If this posting was helpful, please click on the Yes button. Regards, Michael Arch. "Gary" wrote: Have a work sheet 1500 name addresses phone # email address and company names all in one cell. the first and last names were easy now Im having prob with email and company names company names are in 3 cells like long/&/Foster/ dont know how to combine I get getting confused with the formulas there are 1500 cells need to be combined and phone # and email address Thanks Gary |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do I merge cells into one then delete the original cells? | Excel Worksheet Functions | |||
| Merge of cells | Excel Worksheet Functions | |||
| Merge Cells | Excel Discussion (Misc queries) | |||
| Merge Two Cells | Excel Discussion (Misc queries) | |||
| How do I merge cells in Excel, like just 2 cells to make one big . | Excel Discussion (Misc queries) | |||
Linear Mode
