how do I combine cells

  • Thread starter Thread starter Paul Sitton
  • Start date Start date
P

Paul Sitton

I have names and addresses in a workbook that are all in separate cells. One
cell has first name, the next cell has last name. I want to combine those
two into one cell. How do I do it?

Thank you,

Paul
 
Concatenate them.
A1 = First
B1 = Last

In C1 enter:
=A1&B1
And you'll get "FirstLast".

If you adjust the formula:
=A1&" "&B1
You'll get "First Last".
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

I have names and addresses in a workbook that are all in separate cells. One
cell has first name, the next cell has last name. I want to combine those
two into one cell. How do I do it?

Thank you,

Paul
 
Okay, I made this entry in C1: =A1&B1. Now what? What do I do to make that
information appear in C1?
 
In a private exchange, column C was formatted as text.

This was to be used for some kind of label processing.

I suggested using word for the mailmerge and excel as the database (and not
combining the fields).
 
Back
Top