displaying my formula in a different cell

[Harpaz]

Hello everyone,
I'm studying to be an accountant and because of covid all of my tests are online in excel.
we where told that besides the calculations that we are doing we also need to show the formula itself in the cell next to it by putting a space before the = sign.
something like that:
Untitled.png

Now, is there any way to automate this process and not copy & paste the cell every time? something to take the formula of the cell itself and string a space bar before it?
cuz in the exam it will take too much time to do it manually.

thanks in advance & sorry for my English.

[Sam Capricci]

you could try something like this and dragged down... =FORMULATEXT(D2)
assuming the formula you want to display is in D2, adjust as needed.

[Sam Capricci]

and if you absolutely need a space before the formula then add substitute to it like this...
=SUBSTITUTE(FORMULATEXT(D2),"=","= ")