0

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?

ᔕᖺᘎᕊ
  • 6,393
user420104
  • 1

1 Answers1

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,958