| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Merging three cells into one
I have four cells I want to merge into one cell.
I have used the "=A1 & " " & B1 & " " & C1 & " " & D1 to combine them into one cell - but what do I use to tell it to not put a space if there is no middle initial or no suffix? Thanks A1 A2 A3 A4 John D. Ameen Kenneth E. Amos Jr. Brett Anderson Gregory T. Anderson |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| merging cells together but keeping all data from the cells | Excel Discussion (Misc queries) | |||
| merging of cells | Excel Discussion (Misc queries) | |||
| Merging Cells | New Users to Excel | |||
| Merging Cells | Excel Discussion (Misc queries) | |||
| Merging Cells | Excel Worksheet Functions | |||
Threaded Mode
