Text
Strip all numeric digits (0–9) from a text string (TEXTSPLIT & TEXTJOIN)
Remove digits 0–9 from display text, or replace digit and separator boundaries with spaces. Keep the original identifiers.
Remove ASCII digits with multiple delimiters
This is a lossy text transformation: different identifiers can produce the same result. Preserve the source value and do not use the cleaned output as a unique key or a deliverable address.
Passing an array constant of all 10 digits {"0","1","2","3","4","5","6","7","8","9"} as the delimiter to TEXTSPLIT(A2, {"0","1","2","3","4","5","6","7","8","9"}, , TRUE) splits out every digit in one shot! Rejoining the surviving text fragments with TEXTJOIN("", TRUE, ...) and wrapping TRIM collapses leftover spaces cleanly!
Only ASCII digits 0–9 are removed. Other numeral scripts and punctuation remain. The second formula inserts spaces between surviving pieces, so AB12CD becomes AB CD; the first joins them as ABCD. IFERROR returns blank for any error, not only all-digit input, so inspect source errors separately.
| Raw Alphanumeric Input (A2) | After Digit Strip & TRIM | Digits/hyphens removed (other characters can remain) |
|---|---|---|
| "1450 Oakridge Blvd 402" | "Oakridge Blvd" | "Oakridge Blvd" |
| "SKU-9984 Hydraulic Valve 2" | "SKU- Hydraulic Valve" | "SKU Hydraulic Valve" |
| "90210" (Pure digits) | "" (Empty string, IFERROR-safe!) | "" |
Strip all digits 0–9 and collapse extra spaces
IFERROR(..., "") ensures a cell containing ONLY digits ("90210") returns "" cleanly instead of #CALC! when ignore_empty drops all tokens.
=TRIM(IFERROR(TEXTJOIN("", TRUE, TEXTSPLIT(A2, {"0","1","2","3","4","5","6","7","8","9"}, , TRUE)), ""))Strip both digits 0–9 AND hyphens/underscores in one delimiter list
Adding "-" and "_" to the delimiter array turns "SKU-9984_Hydraulic_Valve_2" into "SKU Hydraulic Valve".
=TRIM(IFERROR(TEXTJOIN(" ", TRUE, TEXTSPLIT(B2, {"0","1","2","3","4","5","6","7","8","9","-","_"}, , TRUE)), ""))Try the example
Use the original values or change them to test your understanding.