I have a sheet with:
A B C
7 5 =A1+B1
So, C1=12.
Is it possible that D1 shows the numbers 5,7 used in the sum in C1?
Asked
Active
Viewed 162 times
0
ᔕᖺᘎᕊ
- 6,173
- 4
- 33
- 45
-
It is difficult to understand what you are asking. Please reword your question to better explain what you are attempting to do. – CharlieRB Feb 18 '15 at 12:30
-
So, do you want to basically *show* the formula in D1, and *use* the formula in C1? – ᔕᖺᘎᕊ Feb 18 '15 at 12:45
1 Answers
2
You simply use the CONCATENATE function:
=CONCATENATE(A1,"+",B1)
Or you can use the concatenate operator:
=A1 & "+" & B1
In both cases the numeric cells are converted to strings automatically.
Following the suggestions in the comments, you can combine the calculation and the result in the same cell:
=A1 & "+" & B1 & "=" & (A1+B1)
In all cases you may want to set right alignment for the cell, which is the default for numbers, but not for text.
AFH
- 17,300
- 3
- 32
- 48
-
Maybe it'd also have a `"=",SUM(A1,B1)` included. `=CONCATENATE(A1,"+",B1,"=",SUM(A1,B1))` or, alternatively, `=A1&"+"&B1&"="&A1+B1` – Engineer Toast Feb 18 '15 at 12:58
-
@EngineerToast - Yes, of course. I would normally use `&`, but I thought the CONCATENATE function needed less explanation. – AFH Feb 18 '15 at 13:12
-
You may want to edit your answer to include the suggestion. Given the nature of this site, too much explanation is better than lack of details. – Raystafarian Feb 18 '15 at 14:47