Merging

M

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!
 
M

Mindy

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

jlucy

you forgot an "&"

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

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