Reference two different cell in a single cell

Question

Hi everyone,

I need to reference a two different cells in a single cell. Normally, you could link a cell to another cell by writing something like "=C11". I need to display two different cells in one, separated by a comma (or a space or something else, that doesn't matter).

So if C11 was the word 'cost', and D11 was a price, lets say $1,000, I would need to reference both of those in a single cell using something like "=C11, D11" and have the single cell read "Cost, $1,000".

Any ideas? Thanks!

Answer 1

You can use & to concatenate (combine) text values:

=C11&", "&TEXT(D11,"$#,###")

Answer 2

Hope this helps

best wishes

Answer 3

G61 is a complicated sumif statement of values that are linked to another document. Is there any way that I can extract just the value from G61 into another cell for use in the concatenation formula?

Answer 4

What is in G61--- it must be a number

best wishes

Answer 5

Hi Bernie,

Thanks for the quick reply. Unfortunately my cell is not being formatted properly. The second cell contents do not appear; the cell should read $0. I've attached some screenshots. One is the formula, and one is the improperly formatted cells.

Does anything stand out to you that would cause this? Could the source of the second referenced cell be the issue?

Thanks!