From the course: Cert Prep: Excel Associate - Microsoft Office Specialist for Office 2019
Unlock the full course today
Join today to access over 22,400 courses taught by industry experts or purchase this course individually.
Format text using the CONCAT() and TEXTJOIN() functions
From the course: Cert Prep: Excel Associate - Microsoft Office Specialist for Office 2019
Format text using the CONCAT() and TEXTJOIN() functions
- [Instructor] If you have text in two columns that you need to combine into one column, then you'll want to use CONCAT or TEXTJOIN. In this video, we're going to first take a look at Flash Fill, which we'll use to join text together from two columns, giving Excel an example of the end result. We'll then look at CONCAT, which is used to join text without a delimiter, so you can join the two together but there won't be any spaces or anything separating it, such as a comma. We'll then take a look at TEXTJOIN. Now you can use TEXTJOIN to join text together with a delimiter, with a comma and / or a space. Let's jump right into our Join Workbook and take a look at our Customers Worksheet. First I'll show you how you can use Flash Fill to combine information from two or more columns. I'll show Excel the example of how I want the information to be entered. We'll begin by selecting all the cells that we will be using Flash Fill to fill in. And then in my first cell I'll type in Daphne Meyer…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Contents
-
-
-
-
-
-
-
Insert relative, absolute, and mixed references8m 7s
-
Reference named ranges and named tables in formulas3m 35s
-
Using the AVERAGE(), MAX(), MIN(), and SUM() functions3m 11s
-
Count cells using the COUNT(), COUNTA(), and COUNTBLANK() functions2m 41s
-
Perform conditional operations using the IF() function4m 13s
-
Format text using the RIGHT(), LEFT(), and MID() functions2m 36s
-
Format text using UPPER(), LOWER() and LEN() functions2m 21s
-
Format text using the CONCAT() and TEXTJOIN() functions4m 42s
-
Challenge: Perform operations using formulas and functions28s
-
Solution: Perform operations using formulas and functions4m 55s
-
-
-
-