Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.
I have a list of phone numbers entered into Google spreadsheet in this format: (404) 313-2974
How can I convert this entered cell into 404-313-2974?
=SUBSTITUTE(SUBSTITUTE(A1, "(", ""), ") ", "-")
=ARRAYFORMULA(IF(LEN(A1:A), SUBSTITUTE(SUBSTITUTE(A1:A, "(", ""), ") ", "-"), ))
Required, but never shown
2 months ago
1 month ago