ISVALIDMOBILE
Intro
Checks if entered mobile number is structurally valid or not. Currently this validation is done for Indian mobile numbers as follows:
- 10 digits
- First digit should start with 7 / 8 / 9
- Optional prefix of 0 or +91 or (+91)
Syntax
=ISVALIDMOBILE(mobile_number)
Input
mobile_number(String)
Cell Reference or Text containing mobile number
Output
(Boolean) Validation result as TRUE / FALSE
Code
Target Platform:
Function ISVALIDMOBILE(mobile_number As String) As Boolean
Dim expr As New RegExp
expr.Pattern = "^(\(\+91\)|\+91|0)?[7-9][0-9]{9}$"
ISVALIDMOBILE = expr.Test(mobile_number)
End Function
/**
* Structurally validates if given Indian mobile number is correct or not
*
* @param {string} mobile_number Mobile Number (India) to validate
* @return TRUE/FALSE
* @customfunction
*/
function ISVALIDMOBILE(mobile_number) {
return /^(\(\+91\)|\+91|0)?[7-9][0-9]{9}$/g.test(mobile_number);
}
Function ISVALIDMOBILE(mobile_number As String) As Boolean
Dim expr As New RegExp
expr.Pattern = "^(\(\+91\)|\+91|0)?[7-9][0-9]{9}$"
ISVALIDMOBILE = expr.Test(mobile_number)
End Function
/**
* Structurally validates if given Indian mobile number is correct or not
*
* @param {string} mobile_number Mobile Number (India) to validate
* @return TRUE/FALSE
* @customfunction
*/
function ISVALIDMOBILE(mobile_number) {
return /^(\(\+91\)|\+91|0)?[7-9][0-9]{9}$/g.test(mobile_number);
}
Example
Dependency (VBA)
This Excel VBA Macro uses Regular Expression feature, which is not available by default. So it has to be referenced in VBA Project using below steps
- In Excel press Alt + F11 which will open VBA Macro editor
- Go to Tools > References which will open VBA Project References dialog
-
Locate & Tick Microsoft VBScript Regular Expression 5.5 as shown in below image
- Click OK & close VBA Window
