Merging Columns

[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?

 

[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 (e-mail address removed)

 

[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

 

[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
.