Transposing Multiple Cell references as Multiple Values
 

Hi Everyone

Sometimes it is useful for me to show that a cell contains a string of
numbers which make up a total.

For instance, I would show in a Cell that the total you see ($1000) is made
up of $700 + $300

Sometimes, those individual amounts come from different sources / links.

So, (as an example) H11 ($700) plus G20 ($300) = $1000

In the cell it shows = H11 + G20

Is there any function which will transpose those cell references to the
amounts they represent WITHOUT summing them in the cell?

IE I would like to get = H11 + G20 to show = 700 + 300
NOT =1000

Does anyone have any ideas?
This kind of thing is very useful for reconciliations etc.

thanks!

Transposing Multiple Cell references as Multiple Values
 

One way would be:

=TEXT(H11,"0")&" + "&TEXT(G20,"0")

but this is specific to your particular example, rather than being a
generic formula, i.e. in another cell the references might be
completely different).

Hope this helps.

Pete

On Nov 7, 11:35 pm, LinLin wrote:
Hi Everyone

Sometimes it is useful for me to show that a cell contains a string of
numbers which make up a total.

For instance, I would show in a Cell that the total you see ($1000) is made
up of $700 + $300

Sometimes, those individual amounts come from different sources / links.

So, (as an example) H11 ($700) plus G20 ($300) = $1000

In the cell it shows = H11 + G20

Is there any function which will transpose those cell references to the
amounts they represent WITHOUT summing them in the cell?

IE I would like to get = H11 + G20 to show = 700 + 300
NOT =1000

Does anyone have any ideas?
This kind of thing is very useful for reconciliations etc.

thanks!