Normalizing telephone number string formats help needed

[Aceso]

I need help in reframing telephone numbers in this format

(212) 555-1212 to

2125551212

Thanks for your guidance
Steve @ Aceso

[oeldere]

This is one option.

I'm sure there are better options.

See the attached file.

[VBA FTW]

Does it need to be a macro? You could use the SUBSTITUTE formula to accomplish this. If you're concerned about losing leading zeros, combine the TEXT and SUBSTITUTE formulas and give the text a 0000000000 format via the TEXT formula, use the SUBSTITUTE formula to substitute ( with "", ) with "", and - with ""

[Aceso]

Thanks for the suggestions. All were good!