combining two text columns into one

F

ferde

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

David Biddulph

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

Prasadkakarla

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
 
J

JMB

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)
 
Top