How to display formula in excel? [Solved/Closed]

Report
-
 Daniel -
hi everyone, for example i have A1=H and A2=G, and A3=A1+A2 how do i make A3 show a final result of "H+G",display text instead of calculating the formula?

2 replies


Dear Sir,

You should write the formula like the below.

=E3+E6

and then press enter to obtain its results. You should insert the cell address.

Thank you.
i figured it out you need to put =A1&"+"&A2, thanks guys

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!