Dependent Droplist IF selected format phone number accordingly

Hello,

I have a series of dependent drop lists and a cell which asks for a phone number. I would like if the selection in the previous cell is North America, the format of (111) 111-1111 is chosen. if the user enters the improper format I would like them to be prompt with an error "Improper Format - <Proper Format>", clear contents, and re-select the cell otherwise if valid select the next cell. It would need to strip out the leading 1 incase an international code is entered and also special characters such as "(",")","-","+","_" as well as spaces. The next problem is that it would have to change format to if another selection is chosen. The other two selections are Australia and Europe. Europe is more difficult of a format as the area codes vary in length (if you have a suggestion I will gladly take it) I will be dealing predominantly with Sweden whose area codes even vary. For Australia I would like it to be in the format 011 61 1 1111 1111 where 011 61 will be added even if the user does not enter it (or if not possible prompt with proper format). If you need more clarification please let me know

The cell asking which continent is G35 and options are "","Australia", "Europe", "North America"
The cell asking for a phone number is K47
The next cell on valid response is G50

Hi Arkadi, The user will enter this number so I do not have sample data. since each user is from a different background I want to avoid them entering in the format incorrectly by doing this I hoped to take the common entries and strip them down to just 10 digits (US/Canada) for example. That is why I wanted to eliminate the characters like +,-,(,),_ and spaces. so even if the person wrote (555) 555-5555 (proper format) the code would strip it to be just 5555555555 and then reformat to (555) 555-5555 I would like it to replace the entered value rather than just display it in that format (I believe that is what format cell/special/phone number does). I also want to avoid the international entry of +1 (555) 555-5555 I suppose I could prompt them that it is incorrect format but would like to make it as quick as possible for the user (if possible). ie. be able to enter in "-" and brackets or simply just numbers. Hope I clarified. I have plenty to work on myself just had a few things I wanted to do with it that I didn't know how. Thanks again.

Hi Arkadi,

Curious if you had any progress on this?

Hi Arkadi,

Curious if you had any progress on this?