How do I apply the formula as described here..


which is this part:

=CONCATENATE(""&LEFT(A1,10)&" ...")

to an entire separate column along side it?

basically I want to trim a column to say max 10 characters and put the result on a new entire column side by side.

I have tried and enclosed it in ARRAYFORMULA like this one:


but throws a limit error and it seem not to work.

1 Answer 1


CONCATENATE will try to join everything inside its parentheses; so applying it to an entire column will cause Sheets to try to form one string from all data in that column, hence the limit error.

The ampersand alone does this in arrays.

This is how I would approach this (keeping in mind that I can't see your actual data):


  • Thanks Erik! I guess I got confused and only needed the LEFT function. This works perfectly, problem solved. Commented Jul 31, 2021 at 4:13
  • Glad to hear you're all set.
    – Erik Tyler
    Commented Jul 31, 2021 at 17:08

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.