On Jun 4, 2:22 pm, tralst wrote:
I know that I can show the work in a formula by simply using a &. Example,
with A1 =2 and A2 =3, I type =A1+A2 in a cell This can be converted to the
cells values by entering =A1&"+"&A2. This will return 2+3 in the cell. My
question. Is there a shortcut to accomplish this?

I think you might be interested in the Evaluate Formula feature.
Typically, you select the cell with the interesting formula, then
click on Tools - Formula Auditing - Evaluate Formula. Even though
the feature has some limitations, it is often helpful in debugging or
understanding many complex formulas.