“Concatenation” means pushing things together, chaining things together, or joining things together.

It’s the opposite of pulling apart (techniques like text to columns, textsplit, etc. in Excel).

What’s Inside

• 0:00 Welcome
• 0:15 What is concatenation??
• 0:22 Pushing together vs. pulling apart
• 0:45 Download the spreadsheet
• 1:06 Concatenating first names and last names together
• 1:46 AnnEmery is =A4&B4
• 2:58 Ann Emery is =A4&” “&B4
• 3:40 =proper(A4&” “&B4)
• 5:02 =trim(proper(A4&” “&B4))
• 5:40 CityState is =A13&B14
• 6:05 City State is =A13&” “&B14
• 6:38 City, State is =A13&”, “&B14
• 6:53 Similar techniques: =concat

Download the Spreadsheet

It’s here: https://depictdatastudio.kit.com/concatenationinexcel