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 trie
entering =A1,B1 or =A2, B2 but that doesn't seem to work. How could
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 trie
entering =A1,B1 or =A2, B2 but that doesn't seem to work. How could
refer to multiple cells in a single cell?

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

 

[scottfoxall]

Just to expand on SAP Pod:

Use
=A1 & "," & B1

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