| 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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Merging three cells into one
=A1&IF(B1="",""," "&B1)&C1&IF(D1="",""," "&D1)
Hope this helps. -- John C "Randi" wrote: 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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Merging three cells into one
Actually, this one should have been:
=A1&IF(B1="",""," "&B1)&" "&C1&IF(D1="",""," "&D1) -- John C "John C" wrote: =A1&IF(B1="",""," "&B1)&C1&IF(D1="",""," "&D1) Hope this helps. -- John C "Randi" wrote: 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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Merging three cells into one
or, if you like....
=TRIM(A1&" "&B1&" "&C1&" "&D1) -- John C "Randi" wrote: 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 |
| Reply |
| 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 | |||
Hybrid Mode
