All lessons
Text FunctionsbeginnerPro

Working with Text

Combine, split, and clean up text with LEFT, RIGHT, and CONCATENATE — handy for names, codes, and messy imported data.

Read the full guide to The MID Function (and LEFT, RIGHT) in Excel →

Working with Text is a Pro lesson

Upgrade to Pro to unlock this lesson and every other lesson on Excel Practice Lab.

See Pro plans