Best on desktop
The spreadsheet workspace needs more room than this screen offers. Switch to a laptop for the full experience.
An ops analyst's "strip formatting" formula is a 5-deep nested SUBSTITUTE that's painful to edit and even harder to extend:
=VALUE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A2,"$",""),",",""),"(",""),")",""),"%",""))
It works — but adding a sixth character (e.g., + or whitespace) means another nesting level and re-indenting the whole chain.
REGEXREPLACE collapses this into one call:
=VALUE(REGEXREPLACE(A2, "[$(),%]", ""))
The character class [$(),%] matches any of the 5 characters in one pass. Adding a sixth means appending one character inside the brackets — no nesting changes.
The data at A2:A13 holds amounts mixed with various formatting characters. None of the values are negative; the parens are decorative.
Your task:
$, ,, (, ), % and returns the numeric value.Graded cells: B2 ($1,234.56 → 1234.56), B5 ((25) → 25), B8 ($50,000 → 50000).