Merging

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Mindy - 21 Nov 2005 22:12 GMT

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!

Reply to this Message

ufo_pilot - 22 Nov 2005 14:50 GMT

Try:

=A1&B1&C1

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

Reply to this Message

Mindy - 23 Nov 2005 21:00 GMT

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

> Try:
>
[quoted text clipped - 4 lines]
> > merging 2 cells. Would this be the proper formula for merging 3 cells or are
> > we doing something wrong? Thank you for your help!

Reply to this Message

jlucy - 30 Nov 2005 22:58 GMT

you forgot an "&"

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

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

> still not quite right. . . say A1=Mindy, B1= Jo and C1=Thomas, I need spaces
> between those words.
[quoted text clipped - 7 lines]
> > > merging 2 cells. Would this be the proper formula for merging 3 cells or are
> > > we doing something wrong? Thank you for your help!

Reply to this Message