Best on desktop
The spreadsheet workspace needs more room than this screen offers. Switch to a laptop for the full experience.
You're a customer-support analyst loading 12 phone numbers into a dialer that requires digits only — no parentheses, no dashes, no dots, no spaces. The source data uses mixed formats: (555) 123-4567, 555.987.6543, 555-555-1212, 555 444 3333, etc.
Your task:
+1 800 555 1212) produce 11 digits — the formula should handle both without special-casing.The two acceptable patterns:
=VALUE(REGEXREPLACE(A2, "[^0-9]", "")) — one regex replaces all non-digit characters; VALUE coerces the result to a number.(, ), -, ., and space individually, then VALUE.Graded cells: B2 ((555) 123-4567 → 5551234567), B5 (212.555.0199 → 2125550199), B9 (+1 800 555 1212 → 18005551212).