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?