Displaying multiple cell references in 1 cell

  • Thread starter Thread starter aposatsk
  • Start date Start date
A

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
 
aposatsk said:
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?
Click to expand...

In your first example, try using '&' sign instead (so =A1&B1) - I thin
that's what you are looking for
 
Just to expand on SAP Pod:

Use
=A1 & "," & B1

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Referencing a cell even if its contents are moved moved/replaced 6
formula to display cell address 2
Numerating Cells. 2
Copy multiple cells to one cell 10
referring to formula in a non active cell from active cell 1
Dynamic Cell References in Excel 2
if, then display next cell 4
Average problem 1

Back
Top