Forum Discussion
TEXTJOIN string result not returning all values
I have a column of data (list of names) that need to be separated by a comma (and the returning string data then copied)
Data is in 1184 Rows
Characters circa 24000 (below cell character limit)
Formula used
=TEXTJOIN(",",TRUE,$A:$A)
Returning results up to Row 385 only
Thank you in advance for any advice / workaround to resolve
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.
2 Replies
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.
