This is an Eval Central archive copy, find the original at depictdatastudio.com.

“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