Is there a way where you could display both the formula and its out put in the same cell.
For instance:
I am using a "substitution" formula which removes dashes from numbers- I want the output of that formula to be displayed in the same cell.
OR:
If there is a way excel can automatically...