All tracks
Text function essentials
Intermediate 2 hr 11 exercises
Parse, clean, and combine text using the core text-manipulation formulas Excel users rely on every day.
What you'll learn
- Join values from multiple cells into a single string with CONCATENATE and CONCAT
- Clean imported text by stripping extra spaces, fixing case, and removing unwanted characters with TRIM, PROPER, and SUBSTITUTE
- Extract fixed-length pieces of a string using LEFT, RIGHT, and MID
- Pull out variable-length pieces — file extensions, email domains, address parts — by combining FIND with LEN
- Layer text functions together to parse messy real-world data like names and addresses into clean columns
Functions you'll practice
Exercises in this track
0 of 11 completed 0%
1
CONCATENATE names
BeginnerCombine first name and last name columns into a full name.
2
Combine text with CONCATENATE
BeginnerCombine first and last names into full names using the CONCATENATE function.
5
The Substitute function
BeginnerYou can use the Substitute function for all kinds of textual replacing. Try changing the X in cell A2 below into a 1 by using SUBSTITUTE in cell B2....
6
Clean phone numbers
IntermediateStandardize phone numbers by removing parentheses, dashes, and spaces.
10
Clean and standardize names
AdvancedStandardize company names (remove Inc/LLC/Corp, handle "The", title case).