Formula on a sheet to pick up text only from another sheet

I keep getting the formula and not the relevant text as a result. What is the bext way to rectify this.

press CTRL + the button to

press CTRL + the button to the left of 1