How to display formula in excel?

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?

2 responses

Blocked Profile
Apr 24, 2010 at 06:40 AM
Dear Sir,

You should write the formula like the below.


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