I would like to show the formula of a calculation in one cell and the answer
in another. Do I have to retype as text? Or, is it possible to show both
simultaneously with just one formula? Is this possible?

Example, in cell A6 type =sum(A1:A5) and have the formula show in cell A6
and the answer to the formua in cell B6.