Good Day,
I am looking for help on extending/adjusting my current formula.
Currently I am using : =REPLACE("("&LEFT(A1,3)&") "&RIGHT(A1,LEN(A1)-3),10,,"-")
to do the following:
A B
1 0436423447 (043) 642-3447
I now want help to do more or less the same, as per example below.
A B
1 0436123456 0431234567 (043) 612-3456 (043) 123-4567
Any suggestions?Attachment 384324
Bookmarks