Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I have two columns with a first name in one and the last name in the other, I
would like to combined them into one column, what the best way to do this? thx |
#2
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
=A1 & " " & B1 in cell C1, for example and drag down
Regards Trevor "Roger" wrote in message ... I have two columns with a first name in one and the last name in the other, I would like to combined them into one column, what the best way to do this? thx |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
space in cell | Excel Discussion (Misc queries) | |||
reformat a cell from last name, first to first space last? | Excel Discussion (Misc queries) | |||
Don't allow a space in a cell...how to prevent? | Excel Discussion (Misc queries) | |||
White Space in a Cell | New Users to Excel | |||
Removing a space within a cell | Excel Worksheet Functions |