| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Concatenate first, middle and last names
I have first, middle and last names in 3 different columns. How do I
concatenate them in another column so I have spaces between them but when there's no middle name it doesn't show extra spaces in the result? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Concatenate first, middle and last names
Hi
How about this: =TRIM(A1 & " " & B1 & " " & C1) Regards, Per On 24 Sep., 04:15, liliamma wrote: I have first, middle and last names in 3 different columns. How do I concatenate them in another column so I have spaces between them but when there's no middle name it doesn't show extra spaces in the result? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Separating Full Names into First Middle and Last | Excel Discussion (Misc queries) | |||
| how to get the middle name | Excel Worksheet Functions | |||
| how to get the middle name | Excel Worksheet Functions | |||
| Remove middle initial from "first name middle initial" | Excel Discussion (Misc queries) | |||
| I know how to concatenate ,can one de-concatenate to split date? | New Users to Excel | |||
Linear Mode
