DATA VALIDATION
Use this formula in Custom Data Validation:
=ISNUMBER(FIND("P",B1))
Regards,
Stefi
€˛aditya€¯ ezt Ć*rta:
data in column B is of 9 or 10 or 11 or 12 digit.
In every case it contains alphabet "P" whereas others are digit.
e.g. 10P060509
125P695847
how can i check this through data validation?
|