- Left() Function Examples
View two examples of Excel’s Left function used to extract the “last name” from a “complete name” in a spreadsheet cell.
- Len() Function Example 1
View an example of Excel’s Len function used to find the number of characters in a “Compete Name” in a spreadsheet cell.
- Search() Function Examples
View examples of Excel’s Search function used to find the locations of specific characters used to separate first and last names in text strings representing “complete names.”
- Right() Function Examples
View examples of Excel’s Right() Function used to extract text strings from the RIGHT of text strings representing “Complete Names” in spreadsheet cells.
- Mid() Function Example
View a video demonstrating Excel’s Mid() function used to extract text strings of “first names” from the middle of “Complete Name” text strings in spreadsheet cells.
- Text Type Functions Challenge
Challenge yourself to use appropriate text type functions to extract the first, last, and middle names from a set of “complete” names.
- Intro to Text Type Functions for Separating Text
An introduction to separating text strings in Excel using the LEFT, RIGHT, MID, SEARCH, and LEN functions. Includes two examples and a challenge you can try on your own before watching the solution.
- Concatenate() Function Examples 1
View two examples using Excel’s Concatenate function to create Complete Names by joining together first, last, and middle names.
- Concatenate() Function Examples 2
View examples of Excel’s Concatenate function used to create appropriate, dynamic, text strings for the outcome values of IF functions.
- Concatenate() Function Challenges
Challenge yourself to use Excel’s Concatenate Function, and any other necessary functions to construct Complete Names from First, Last, and Middle names. Solutions available.
- Intro to Concatenate(), a Text Type Function for Joining Text
An introduction to joining text strings in Excel using the CONCATENATE() function. Includes examples and a challenge for you to try on your own before watching the solution.
