I have a text cell that needs to in the "Clipping" wrap mode, cutting most of it away from view. Or is at the end of the range. Or is too long to be displayed. Normally, I would read the cell by selecting it and reading it in the formula bar.

But if the cell is a result of a formula (such as =join(", ", A1:A300) which results in a long text) the formula bar only displays the formula, not the resulting text.

Is there some sort of keyboard shortcut or setting that helps with this?


Fast way is to copy and paste values in another cell

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.