Forum Discussion

Mike__580's avatar
Mike__580
Copper Contributor
Sep 27, 2023

View bottom text with large amount in cell

I have cells with a large amount of text. Cannot increase cell height, but want to see the bottom of the text., not as important to see the top. The text is activity log information newest is always appended to the bottom of the text.

excel

2 Replies

  • OliverScheurich's avatar
    OliverScheurich
    Gold Contributor
    Sep 27, 2023

    Mike__580 

    =RIGHT(E7,100)

     

    This formula always returns the rightmost 100 characters of cell E7. Does this help in your actual sheet?

     

    • Mike__580's avatar
      Mike__580
      Copper Contributor
      Sep 27, 2023

      maybe not since it would be a separate function (formula). More cumbersome that if I could just bias the text in the cell to show the bottom instead of the top. Right now the only way to see it is in the edit mode when adding more text lines. Thanks for the response.