Merging

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!
 
still not quite right. . . say A1=Mindy, B1= Jo and C1=Thomas, I need spaces
between those words.
 
you forgot an "&"

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

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