SOLVED

How to view only text output after using XLOOKUP function?

%3CLINGO-SUB%20id%3D%22%5C%26quot%3Blingo-sub-3172327%5C%26quot%3B%22%20slang%3D%22%5C%26quot%3Ben-US%5C%26quot%3B%22%3EHow%20to%20view%20only%20text%20output%20after%20using%20XLOOKUP%20function%3F%26lt%3B%5C%2Flingo-sub%26gt%3B%3CLINGO-BODY%20id%3D%22%5C%26quot%3Blingo-body-3172327%5C%26quot%3B%22%20slang%3D%22%5C%26quot%3Ben-US%5C%26quot%3B%22%3E%3CP%3EHi%2C%26nbsp%3B%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3ECould%20someone%20kindly%20support%2C%20I'm%20having%20a%20problem%20where%20I'm%20not%20able%20to%20see%20the%20full%20description%20of%20it%20when%20I%20click%20on%20the%20cell%2C%20I%20only%20see%20the%20formula.%20Is%20it%20possible%20to%20fix%20this%3F%26nbsp%3B%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3EI%20have%20attached%20a%20sample%20excel%20to%20illustrate.%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3EThanks%20so%20much%2C%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3EAmy%26lt%3B%5C%2FP%26gt%3B%26lt%3B%5C%2Flingo-body%26gt%3B%3CLINGO-LABS%20id%3D%22%5C%26quot%3Blingo-labs-3172327%5C%26quot%3B%22%20slang%3D%22%5C%26quot%3Ben-US%5C%26quot%3B%22%3E%3CLINGO-LABEL%3EExcel%26lt%3B%5C%2Flingo-label%26gt%3B%26lt%3B%5C%2Flingo-labs%26gt%3B%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3C%2FLINGO-SUB%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3172327%22%20slang%3D%22en-US%22%3EHow%20to%20view%20only%20text%20output%20after%20using%20XLOOKUP%20function%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3172327%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECould%20someone%20kindly%20support%2C%20I'm%20having%20a%20problem%20where%20I'm%20not%20able%20to%20see%20the%20full%20description%20of%20it%20when%20I%20click%20on%20the%20cell%2C%20I%20only%20see%20the%20formula.%20Is%20it%20possible%20to%20fix%20this%3F%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20attached%20a%20sample%20excel%20to%20illustrate.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20so%20much%2C%3C%2FP%3E%3CP%3EAmy%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3172327%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Contributor

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 have attached a sample excel to illustrate.

 

Thanks so much,

Amy

5 Replies

@AmyYang 

No. That is the way the user interface is designed to work. The formula bar will always show a formula whereas the cell shows the result until you double-click or press F2, then it too will show the formula.

To get a quick look at the cell content, you could toggle the 'wrap text' button on the Alignment group of the Home Ribbon tab.

Hi Peter, noted, thanks kindly for your reply!
best response confirmed by AmyYang (Contributor)
Solution

@AmyYang 

You may click on formula bar with formula and F9

image.png

Esc or Ctrl+Z to return formula back, otherwise it will be substituted by result.

 

One more option is to click on fx

image.png

which shows

image.png

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!