Forum Discussion
Solved
How to view only text output after using XLOOKUP function?
Hi, Could someone kindly support, I'm having a problem where I'm not able to see the full description of it when I click on the cell, I only see the formula. Is it possible to fix this? I h...
You may click on formula bar with formula and F9
Esc or Ctrl+Z to return formula back, otherwise it will be substituted by result.
One more option is to click on fx
which shows
Bit more than in cell.
Hi Sergei, well noted, thank you so much for your two helpful approaches to solve this problem! I am glad and will use this. Thanks!
AmyYang , you are welcome