| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Combine First and Last Name colums to create thrid column of full
What is the formula to combine a2 and b2 to display in c2
A2 = First Name B2 = Last Name C2 = formated Full Name |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Combine First and Last Name colums to create thrid column of full
Try this:
C2: =A2&" "&B2 Does that help? -------------------------- Regards, Ron (XL2003, Win XP) Microsoft MVP (Excel) "Mark M" wrote in message ... What is the formula to combine a2 and b2 to display in c2 A2 = First Name B2 = Last Name C2 = formated Full Name |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Combine First and Last Name colums to create thrid column of f
That worked as well, again, thank you for your assistance.
"Ron Coderre" wrote: Try this: C2: =A2&" "&B2 Does that help? -------------------------- Regards, Ron (XL2003, Win XP) Microsoft MVP (Excel) "Mark M" wrote in message ... What is the formula to combine a2 and b2 to display in c2 A2 = First Name B2 = Last Name C2 = formated Full Name |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Combine First and Last Name colums to create thrid column of f
You're welcome, Mark.......I'm glad I could help.
-------------------------- Regards, Ron (XL2003, Win XP) Microsoft MVP (Excel) "Mark M" wrote in message ... That worked as well, again, thank you for your assistance. "Ron Coderre" wrote: Try this: C2: =A2&" "&B2 Does that help? -------------------------- Regards, Ron (XL2003, Win XP) Microsoft MVP (Excel) "Mark M" wrote in message ... What is the formula to combine a2 and b2 to display in c2 A2 = First Name B2 = Last Name C2 = formated Full Name |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Create initials from Full name | Excel Discussion (Misc queries) | |||
| Combine Two Colums | New Users to Excel | |||
| Display thrid letter formula | Excel Discussion (Misc queries) | |||
| How do I combine 2 or more colums | New Users to Excel | |||
| How to create a chart with Stacking colums and lines with 2 axes | Charts and Charting in Excel | |||
Hybrid Mode
