I'm fond of placing long text in a cell, also would like to learn long
formulas derived from refencing functions like offset, match and row...
Most of the time, I record a long master formula as text to assure that i
have it safely...
Yet due to my scrambled files, wherein I have to copy/move sheets into
another workbook...I see pop-up message like....

"The sheet you are copying has cells that contain more than 255 characters.
When.....only the first 255 characters in each cells are copied"

But after some cross check, the active formula which contains the same
number of characters are completely copied. argghhhh. what a twist...Any
suggested set-up or VBE? pls. help...