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.

Normalize Text List – Excel LAMBDA | Blake Ekelund

Excel Toolkit›Normalize Text List

Normalize Text List

ArraysIntermediate

Splits text on commas, trims spaces, removes blanks, and returns a clean vertical list.

LAMBDA(txt, LET( split, TEXTSPLIT(txt, ","), trimd, TRIM(split), FILTER(trimd, trimd <> "") ))

Parameters

txt

Example Usage

=NORMALIZE_LIST("apple, banana,  , mango")

Pro Tips

Wrap in SORT() for alphabetical lists

Common Issues

TEXTSPLIT requires Office 365