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.

Remove Non-Numeric – Excel LAMBDA | Blake Ekelund

Excel Toolkit›Remove Non-Numeric

Remove Non-Numeric

CleaningAdvanced

Extracts only numbers from a text string using BYROW + TEXTSPLIT.

LAMBDA(txt, LET( chars, MID(txt, SEQUENCE(LEN(txt)), 1), nums, FILTER(chars, ISNUMBER(--chars)), TEXTJOIN("", TRUE, nums) ))

Parameters

txt

Example Usage

=REMOVE_NON_NUMERIC("abc123xyz45")

Pro Tips

Handle decimals by allowing "." in chars

Common Issues

SEQUENCE requires dynamic arrays enabled