Concatenation in Excel

Ann K. Emery

Updated on: May 5th, 2025

Data Analysis

Concatenation, Formulas and Functions, How-To Tutorials, Microsoft Excel, YouTube Videos

“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

More about Ann K. Emery
Ann K. Emery is a sought-after speaker who is determined to get your data out of spreadsheets and into stakeholders’ hands. Each year, she leads more than 100 workshops, webinars, and keynotes for thousands of people around the globe. Her design consultancy also overhauls graphs, publications, and slideshows with the goal of making technical information easier to understand for non-technical audiences.

Weekly Newsletter

Data visualization time-savers in everyday software, like Excel.

Our weekly newsletter is shared with a community of 8,000 researchers, evaluators, and scientists.