Hi,
I am trying to figure out how to have multiple phone number formats in one cell. For example;
I enter 9 digits into cell A1 for a U.S. phone number or 10 digits for a European phone number. I would like cell A1 to format the cell as +1 (123) 456-7891 for 9 digits and + 12 34 567 8910 for 10 digits. Is this possible to do without creating multiple cells? Your help is greatly appreciated.