| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Name Surname combination
I have a worksheet, names and surnames are on different columns. Any
possibility to display both of them on the 3rd column together. Thanks for all the help -- Peace in the world |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Name Surname combination
Hi,
Assume forename and surname in A1 and B1 then in C1 put: =A1 & " " & B1 ' Separated by blank or in VBA: Range("C1").value=Range("A1").value & " " & range("B1").value HTH "Seaman" wrote: I have a worksheet, names and surnames are on different columns. Any possibility to display both of them on the 3rd column together. Thanks for all the help -- Peace in the world |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Name Surname combination
Suggest you add a trim function to remove any spurious spaces at end,
beginning and double spaces in text strings. =trim(A1 & " " & B1) Range("C1").value= trim(Range("A1").value & " " & range("B1").value) -- Cheers Nigel "Toppers" wrote in message ... Hi, Assume forename and surname in A1 and B1 then in C1 put: =A1 & " " & B1 ' Separated by blank or in VBA: Range("C1").value=Range("A1").value & " " & range("B1").value HTH "Seaman" wrote: I have a worksheet, names and surnames are on different columns. Any possibility to display both of them on the 3rd column together. Thanks for all the help -- Peace in the world |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sorting by surname when first name and surname are in the same cel | New Users to Excel | |||
| Split surname from end of name data | Excel Worksheet Functions | |||
| Change around surname and name | Excel Discussion (Misc queries) | |||
| Splitting firstName from Surname | Excel Worksheet Functions | |||
| Display only surname | Excel Worksheet Functions | |||
Linear Mode
