Forum Discussion
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 char...
Cat-C , glad it helped, good luck with your project.
SergeiBaklan Thank you so much, and thanks for sharing the blog post- it looks very insightful. I will definitely investigate. I am not yet very familiar with Power Query but looking forward to learning more about it so that I may deploy it. I appreciate your help!
Cat-C , glad it helped, good luck with your project.