Excel-Format Phone Numbers with Extension Formula

Excel Formula - format phone numbers with extensions
Derived from examples at https://www.extendoffice.com/documents/excel/4287-excel-phone-number-format-with-extension.html

Change a number like 2124567890x123 to (212) 456-7890 x123 assuming this number is in Cell E5

May need to first strip all non-numeric characters first and need to enter next formula with CTRL-SHIFT-ENTER
https://exceljet.net/formula/strip-non-numeric-characters

=TEXTJOIN("",TRUE,IFERROR(MID(A2,ROW(INDIRECT("1:100")),1)+0,""))

="("&LEFT(E5,3)&") "&MID(E5,4,3)&"-"&MID(E5,7,4)&" "&MID(E5,11,99)