I have two possible phone numbers:
One with 9 digits (mobile) and 8 digits (landline), and I need to insert
- after 4 or 5 digits so they appear as
0000-0000 when 8 digits, and
00000-0000 when they are 9 digits.
Also, need to get a country and state codes like this
+00 (00) the numbers inside the parentheses are the state codes.
I managed to get a formula that works with one or another, but not both. Can anyone help?
"+"?? (##) ????-???? > Works for 8 digit numbers
"+"## (##) ?????-???? > Works with 9 digits.
Any help, please?