How can I convert a list of phone numbers from 404-313-2974 to (404) 313-2974?

Question

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 ?

Answer 1

With some regex :

=REGEXREPLACE(
     REGEXREPLACE(A1,"^...","\($0\)")
  ,"\)-","\) ")

First regexreplace job is to add some parenthesis.
Second one is to remove the first hyphen -.

---