Simple Concatenate in Google Docs Spreadsheet

While working on a project involving creating a URL from a set of information entered in a Google Docs form, I ran into the problem that the concatenate formula does not work as an array formula.

This is a simple solution to allow a simple concatenate that works within =ARRAYFORMULA

=ARRAYFORMULA(A2 & B2:B)

A2 will only include what is in cell A2
B2:B will include everything in column B, except B1

Thank you, Docs Help Forums!
http://productforums.google.com/forum/#!searchin/docs/array$20concatenate/docs/OU6QbGWjkVk/6r3PuWzjRboJ

You can make unused form areas blank by using an IF statement

=ARRAYFORMULA (IF (A2:A > 0, B2 & C2:C, ” “))

Leave a comment