Excel FP&A Web Dev Blog

Loading...

Blake Ekelund

Finance ops, half-formed plans, fully-formed spreadsheets.

Work

Excel
FP&A
Web Dev
Blog

Off the clock

Play
On my mindsoon
Golfsoon
MN Sportssoon

Find me

Email
GitHub
LinkedIn

More

Search
Sitemap
Robots

© 2026 Blake Ekelund · Built with Excel, chocky milk, and too many tabs open.

Clean Text – Excel LAMBDA | Blake Ekelund

Excel Toolkit›Clean Text

Clean Text

TextBeginner

Removes leading/trailing spaces, double spaces, and converts text to proper case.

LAMBDA(txt, LET( t1, TRIM(txt), t2, SUBSTITUTE(t1, " ", " "), PROPER(t2) ))

Parameters

txt

Example Usage

 =CLEAN_TEXT("  hello   world  ")

Pro Tips

Use CLEAN() if you need to remove non-printable characters

Common Issues

Does not remove punctuation
Will convert ALL words to Proper Case