Concatenate?
Posted by Dwight on October 25, 2001 4:41 AM
Column G is first names of individuals; column H is last names. Want to consolidate into one column with full name, eg "Richard Gere". Guess the way to do it is concatenate but the examples Excel provides for this are confusing to me & I can't accomplish.
Thanks in advance.
Posted by Manu on October 25, 2001 4:51 AM
Assuming:
Cell A1 = Richard
Cell B1 = Gere
Destination Cell formula should be: =CONCATENATE(A1,B1)
The resulting value for Destination cell would be "RichardGere"
If you would like to add a space so the answer reads "Richard Gere", modify above the above formula to read:=CONCATENATE(A1&" "&B1)
Resulting Destination Cell Value:"Richard Gere"
Hope this helps
Manu
Posted by Dwight on October 25, 2001 5:02 AM
Thanks Manu!
Hi Manu,
The last one should be:
=CONCATENATE(A1," ",B1)
or, just:
=A1&" "&B1
Regards,
Aladin
Posted by Aladin Akyurek on October 25, 2001 5:02 AM
Hi Manu,
The last one should be:
=CONCATENATE(A1," ",B1)
or, just:
=A1&" "&B1
Regards,
Aladin
