How to manipulate your data: Joining and separating strings
Manipulating String Data in Excel: Joining & Separating Text
In this video, we will learn how to manipulate string data in Excel by joining and separating text. This tutorial covers combining columns with CONCATENATE and the ampersand operator, splitting text apart with TEXTBEFORE and TEXTAFTER (including their optional arguments), and extracting fixed-length segments with LEFT and MID. The examples range from merging first and last names to separating an email address into its numeric and letter components and reconstituting it.
Chapters:
0:00 Introduction
0:36 Joining names with CONCATENATE
1:51 Joining names with the ampersand (&)
2:28 Separating text with TEXTBEFORE
3:34 TEXTBEFORE optional arguments (instance, match mode, etc.)
4:39 Separating text with TEXTAFTER
5:34 Joining province and country with a comma delimiter
6:41 Splitting the result with TEXTBEFORE and TEXTAFTER
7:42 Handling multiple delimiters
8:43 Splitting fixed-length data with LEFT and MID
11:02 Reconstituting an email with CONCATENATE
11:38 Recap.
For more information on basic Excel skills, see my Microsoft Excel Basic Guide at https://lib.unb.ca/guides/microsoft-e...
Intro and outro music from Stereoalex at https://icons8.com/music/track/synthw...