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, ” “))

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: