How to display formula in excel?

Solved/Closed
Daniel - Apr 24, 2010 at 05:40 AM
 Daniel - Apr 24, 2010 at 06:47 AM
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?
Related:

2 replies

Blocked Profile
Apr 24, 2010 at 06:40 AM
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.
0
i figured it out you need to put =A1&"+"&A2, thanks guys
0