
Remove phone separators, keep the plus
(201) 555-0123 → 2015550123
21 free Excel templates to format phone numbers. For example, 2015550123 becomes (201) 555-0123. Pick the one that matches your list, download it and paste your data in. No sign-up, no macros.
21 templates

(201) 555-0123 → 2015550123

12015550123 → 2015550123

tel:+12015550123;ext=12 → +12015550123

tel:+12015550123;ext=0012 → 0012

0012015550123 → +12015550123

2079460123, width 11 → 02079460123

2015550123 → (201) 555-0123

2015550123 → +12015550123

(201) 555-0123 and 0012 → (201) 555-0123 ext. 0012

1 + 2015550123 → +12015550123

2015550123 → ******0123

2015550123 + 2015550142 → Phone: 2015550123¶Fax: 2015550142

+12015550123 and 0012 → tel:+12015550123;ext=0012

201-555-0123 Verified + backup → 201-555-0123

Mobile, 201-555-0123, 617-555-0142 → 201-555-0123

201-555-0123 + Do not use → blank

+39065550123, code 39 → 065550123

5550123 + 201 → 2015550123

02079460123 + 0 → 2079460123

0012015550123 + 00 → +12015550123

7042 + example.com → tel:7042;phone-context=example.com