Forum Discussion
AmyYang
Feb 16, 2022Brass Contributor
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...
- Feb 16, 2022
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.