Forum Discussion
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.
Cat-C , glad it helped, good luck with your project.
9 Replies
- SergeiBaklanDiamond Contributor
You can do nothing with that, Excel limit is