Displaying multiple cell references in 1 cell

[aposatsk]

Consider the following:

A-----------B
2-----------5
1-----------5
...

In another cell, i want to display text like "2, 5" and "1, 5". I tried entering =A1,B1 or =A2, B2 but that doesn't seem to work. How could i refer to multiple cells in a single cell?

[SAP PoD]

Consider the following:

A-----------B
2-----------5
1-----------5
...

In another cell, i want to display text like "2, 5" and "1, 5". I tried entering =A1,B1 or =A2, B2 but that doesn't seem to work. How could i refer to multiple cells in a single cell?

In your first example, try using '&' sign instead (so =A1&B1) - I think that's what you are looking for.

If you need the comma, then try =A1&", "&B1

[scottfoxall]

Just to expand on SAP Pod:

Use
=A1 & "," & B1

"SAP PoD" wrote:

>
> aposatsk Wrote:
> > Consider the following:
> >
> > A-----------B
> > 2-----------5
> > 1-----------5
> > ...
> >
> > In another cell, i want to display text like "2, 5" and "1, 5". I tried
> > entering =A1,B1 or =A2, B2 but that doesn't seem to work. How could i
> > refer to multiple cells in a single cell?
>
> In your first example, try using '&' sign instead (so =A1&B1) - I think
> that's what you are looking for.
>
>
> --
> SAP PoD
> ------------------------------------------------------------------------
> SAP PoD's Profile: http://www.excelforum.com/member.php...o&userid=37641
> View this thread: http://www.excelforum.com/showthread...hreadid=573733
>
>