combining two text columns into one
 

I would like to have a formula in column C that would look at column A and
Column B and combine both entries . There are blanks where indicated.
A B C
Bob Bob
Jack Jack
Dick Dick
Nancy Nancy
Mary Mary

Can anyone help me?

combining two text columns into one
 

=A1&B1

Copy down.

"ferde" wrote:

I would like to have a formula in column C that would look at column A and
Column B and combine both entries . There are blanks where indicated.
A B C
Bob Bob
Jack Jack
Dick Dick
Nancy Nancy
Mary Mary

Can anyone help me?

combining two text columns into one
 

Or
=A1&" "&B1
if you want a space between the contents of the two source cells.
--
David Biddulph

"JMB" wrote in message
...
=A1&B1

Copy down.

"ferde" wrote:

I would like to have a formula in column C that would look at column A
and
Column B and combine both entries . There are blanks where indicated.
A B C
Bob Bob
Jack Jack
Dick Dick
Nancy Nancy
Mary Mary

Can anyone help me?

combining two text columns into one
 

There are two types of solution for ur question
sol I : =A1&" "&B1
in this solution if u want a space between both words u can use space

sol II :
= CONCATENATE(A1," ",B1) This is the second solution usually we can use as
per u r data standard no confusions in this. what ever text u want to add
between both the cell u can.

try this and reply me

c u bye
--
Name : K.Prasad
Inventory Manager
CRYSTALGALLERY
DUBAI



"ferde" wrote:

I would like to have a formula in column C that would look at column A and
Column B and combine both entries . There are blanks where indicated.
A B C
Bob Bob
Jack Jack
Dick Dick
Nancy Nancy
Mary Mary

Can anyone help me?

combining two text columns into one
 

Yes. However, if the sample data is representative, there is only one entry
per row. If a space is added to the result, this could screw up any
subsequent lookups or conditional comparisons.

Perhaps the best solution that would satisfy the most possibilities:
=TRIM(A1&" "&B1)


"David Biddulph" wrote:

Or
=A1&" "&B1
if you want a space between the contents of the two source cells.
--
David Biddulph

"JMB" wrote in message
...
=A1&B1

Copy down.

"ferde" wrote:

I would like to have a formula in column C that would look at column A
and
Column B and combine both entries . There are blanks where indicated.
A B C
Bob Bob
Jack Jack
Dick Dick
Nancy Nancy
Mary Mary

Can anyone help me?