Forum Discussion
TEXTJOIN string result not returning all values
A cell has a maximum width of 255 and a maximum height of 409.5 points. This is probably not enough to show the entire result, and since you cannot scroll a cell that contains a formula, you won't be able to view the hidden part.
If you copy the cell then paste as values, you should be double-click the cell and scroll down to see the entire contents.
A cell has a maximum width of 255 and a maximum height of 409.5 points. This is probably not enough to show the entire result, and since you cannot scroll a cell that contains a formula, you won't be able to view the hidden part.
If you copy the cell then paste as values, you should be double-click the cell and scroll down to see the entire contents.
Many thanks for not only providing a solution but taking the time to explain the theory behind.
