D
Debra
I a spreadsheet with first name in one column and last
name in the next column. How can I put them together in
one column?
name in the next column. How can I put them together in
one column?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
C
Chip Pearson
Debra,
You can use the & operator to combine multiple strings in to a single string
.. E.g.,
=A1&B1
or, with an embedded space,
=A1&" "&B1
--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com [email protected]
You can use the & operator to combine multiple strings in to a single string
.. E.g.,
=A1&B1
or, with an embedded space,
=A1&" "&B1
--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com [email protected]
F
Felipe
Debra,
Assuming first name is in column A and last name is in
column B. Type the following in C1:
=A1&" "&B1
And copy down the formula
You can also use the CONCATENATE function:
=CONCATENATE(A1," ",B1)
Regards,
Felipe
Assuming first name is in column A and last name is in
column B. Type the following in C1:
=A1&" "&B1
And copy down the formula
You can also use the CONCATENATE function:
=CONCATENATE(A1," ",B1)
Regards,
Felipe
D
Debra
Fabulous! Thanks very much!
-----Original Message-----
Debra,
Assuming first name is in column A and last name is in
column B. Type the following in C1:
=A1&" "&B1
And copy down the formula
You can also use the CONCATENATE function:
=CONCATENATE(A1," ",B1)
Regards,
Felipe
.