■ FREE GUIDE · DATA CLEANING

Clean Up Messy Data Without Retyping It.

16 text functions for tidying whatever someone just exported and emailed you — LEFT, RIGHT, MID, TEXTSPLIT, TEXTBEFORE, TEXTAFTER, SUBSTITUTE, TRIM and more, each with a one-line explanation of what it does.

GET IT FREE — SENT STRAIGHT TO YOUR INBOX

Free forever. Unsubscribe anytime.

PLACEHOLDER — replace with Top Excel Functions For Data Cleaning cover

9M+

COMMUNITY WORLDWIDE

100,000+

GUIDES DOWNLOADED

100%

FREE, NO CATCH

Emma Chieppor, founder of Excel Dictionary

■ ORIGINSTORY.XLSX · WHO WROTE THIS

The coworker you never had.

Hi — I'm Emma. I built Excel Dictionary because I once sat alone trying to figure out Excel with no one to ask. This guide is the resource I wish someone had handed me back then — the text functions I reach for every time a file lands in my inbox in the wrong shape.

★ 5-TIME MICROSOFT MVP

■ FAQ.XLSX · QUICK QUESTIONS

Before you hand over your email

Is this actually free?

Will I get spammed?

What format is it?

Will this help with my specific messy export?

■ MORE FROM THE BRAND · @EXCELDICTIONARY