Forum Discussion

Cat-C's avatar
Cat-C
Copper Contributor
Jul 19, 2021
Solved

Combining Text Strings with Ampersand (=a1&&" "&a2 formula) cuts off after 32,767 characters

Hi, I am using the following formula to add together long text strings in a worksheet:

=A1&" "&A2 

However, the formula cuts off the text being added together after it hits a certain number of characters in the cell. I used the =LEN(A1) formula to determine that the total number I am able to add together before it cuts off is 32, 767. Is there a setting that I need to change, or something else I can do to get this formula to work? I also notice that when I  entering 3 or 4 of the calculations manually in a column, highlight them, and attempt copying the formula down to apply the formula to the entire data set, it seems to cut off after 70-80 rows.  

 

Resources