CODEWITHSUNDEEP
google-sheets-formulaarray-formulas
Tu PHAN
Tu PHAN

Reputation: 59

Googlesheet : ARRAYFORMULA with CONCATENATE

Any one can help with to see what was wronng in the picture B, we want the result as picture A but when i change formular with Arrayformlas it is not working.

Thank you

enter image description here

Upvotes: 0

Views: 101

Answers (1)

basic
basic

Reputation: 11968

Use & instead of CONCATENATE:

=ARRAYFORMULA(IF(LEN(A:A),A:A&B:B,""))

enter image description here

Upvotes: 1

Related Questions