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
?
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
?
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.
"=",SUM(A1,B1)
included. =CONCATENATE(A1,"+",B1,"=",SUM(A1,B1))
or, alternatively, =A1&"+"&B1&"="&A1+B1
Feb 18, 2015 at 12:58
&
, but I thought the CONCATENATE function needed less explanation.