Forum Discussion
REPT function is not working correctly (for me).
It has nothing to do with the REPT function, nor with the merged cells or the rotated text.
Although a cell can contain up to 32,767 characters, only up to 1,024 characters will be displayed in the cell.
The text that you repeat has 42 characters, so it will be displayed 1,024/42 ~ 24.4 times.
It has nothing to do with the REPT function, nor with the merged cells or the rotated text.
Although a cell can contain up to 32,767 characters, only up to 1,024 characters will be displayed in the cell.
The text that you repeat has 42 characters, so it will be displayed 1,024/42 ~ 24.4 times.
Thank you, Nikolino for your input and suggestions! However, it was HansVogelaar who landed on the issue. I had no idea there was a character display maximum (caveat below) and that's what I keep running into.
I reviewed the older spreadsheets that have data organized in the same way, and they either had a row quantity and a text height that ended up under the 1,024 character display limit, or they had the "merged" rows split up into smaller "segments" where the character limit was right at the end of one of the repeats. The borders between them removed, the text lined up, and the sheets are all protected and the columns aren't "selectable" (until I turn off the protection). This means that, although I have no memory of this whatsoever, I apparently ran into this limit before, understood what was happening, and "fixed" it by configuring/merging the rows in this second fashion, adjusting them all so they looked "perfect", repeated exactly as needed, and then protected everything so it worked and looked beautiful! I have 12 or so spreadsheets from 15 years ago where I did this, and I seriously do not have a single memory of any of this 
. Sorry for taking up your time everyone. And, thanks Hans for pointing out something I have apparently forgotten (I'm getting too old I guess)!