Concat, Concatenate and &

Nope.  They have nothing to do with cats.  Sorry.  If you’re here for the cat memes, you’re going to have to look elsewhere.

They are two Google Sheets formulas that are very useful if you’re organizing information in Google Sheets.  Have first names in one column and last names in another, but need them combined?  Concat has your back.  Have a student’s grade number, but need it to be written out (7th grade instead of just 7) for a mail merge?  Concat is here to help.

Need to combine more than 2 things?  i.e., first, middle & last name?  Concatenate can help you out.  It’s the same as Concat but it works for more than 2 items.

The & operator can perform the same tasks.  It’s all personal preference.

Some tips are listed below the GIF.

Concat & Concatenate Animation

  • Basic format: =CONCAT(first thing, second thing)
    • =CONCATENATE(first thing, second thing, third thing, fourth thing….)
    • =first thing & second thing & third thing
  • The items in the formula can be cell references like here: =CONCAT(A1, B1)
  • The items in the formula can be regular text, just use quotation marks: =CONCAT(“me”, “ow)”.
  • When combining text strings, it puts them together with nothing in between them, so if you want a space, you’ll have to add it yourself – use ” ” if needed – the space is held between those quotation marks.

FILTER Formula in Google Sheets

You can filter using menu buttons and create filter buttons in Google Sheets, but sometimes it’s valuable to setup a FILTER formula.  One such instance is shown in the GIF below: when you have a Sheet that contains data about many students across many grades or classes.  Using a filter formula, you can create a tab for each class or grade.  You can also create tabs for certain criteria (like lower scores that require follow-up).

=FILTER(range, condition1, [condition2, …])

Note from the formula above, that you can actually identify multiple criteria (such as Mr. Kotter’s students who scored below a 75%).

Filter Formula (Google Sheets) Animation