Merging

[Mindy]

We are trying to figure out how to merge 3 cells by using the following
formula: =A1&", "&B1", "&C1 for example. So far it only seems to work for
merging 2 cells. Would this be the proper formula for merging 3 cells or are
we doing something wrong? Thank you for your help!

 

[ufo_pilot]

Try:

=A1&B1&C1

 

[Mindy]

still not quite right. . . say A1=Mindy, B1= Jo and C1=Thomas, I need spaces
between those words.

 

[jlucy]

you forgot an "&"

=A1&", "&B1&", "&C1
not
=A1&", "&B1", "&C1

This also works =CONCATENATE(A1,", ",B1,", ",C1,", ")