| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
validating telephone format
I need to validate that telephone numbers are entered in this format:
###-###-####. I found something that was close: =AND(LEFT(A2,1)="C",LEN(A1)=16,ISNUMBER(SUBSTITUTE (RIGHT(A2,14),"-","")*1),LEN(SUBSTITUTE(RIGHT(A2,13),"-",""))=12) ( it validates this format: C-###-#####-####. But I have not been able to successfully adapt the above to what I need. Any help would be appreciated. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| custom telephone number format | Excel Discussion (Misc queries) | |||
| Can I format telephone numbers? | Excel Worksheet Functions | |||
| Format Telephone Cell Range | Excel Worksheet Functions | |||
| how do i format telephone numbers | Excel Discussion (Misc queries) | |||
| Telephone number format | Excel Discussion (Misc queries) | |||
Threaded Mode
