DATA VALIDATION
 

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?

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?

DATA VALIDATION
 

Select the cell(s) and using data Validation, choose Custom and enter this
formula:
=FIND("P",B2)0
in this case B2 is the first cell in the range selected of a multiple cell
selection.
It will alert if a P is not in the entry, but won't tell you if several Ps
are entered, just if there isn't one.

"aditya" wrote:

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?

DATA VALIDATION
 

it works well only if P is capital letter.
i want to accept p as capital as well as small letter.

pls help

"Stefi" wrote:

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?

DATA VALIDATION
 

it works well only if P is capital letter.
i want to accept p as capital as well as small letter.

pls help


"JLatham" wrote:

Select the cell(s) and using data Validation, choose Custom and enter this
formula:
=FIND("P",B2)0
in this case B2 is the first cell in the range selected of a multiple cell
selection.
It will alert if a P is not in the entry, but won't tell you if several Ps
are entered, just if there isn't one.

"aditya" wrote:

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?

DATA VALIDATION
 

It's always worth looking at Excel help.
From Excel help for the FIND function:
"You can also use SEARCH to find one text string within another, but unlike
SEARCH, FIND is case sensitive and doesn't allow wildcard characters."
--
David Biddulph

aditya wrote:
it works well only if P is capital letter.
i want to accept p as capital as well as small letter.

pls help


"JLatham" wrote:

Select the cell(s) and using data Validation, choose Custom and
enter this formula:
=FIND("P",B2)0
in this case B2 is the first cell in the range selected of a
multiple cell selection.
It will alert if a P is not in the entry, but won't tell you if
several Ps are entered, just if there isn't one.

"aditya" wrote:

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?

DATA VALIDATION
 

You should have specified it in your post! This is case insensitive:
=ISNUMBER(SEARCH("P",B1))
Regards,
Stefi

€žaditya€� ezt Ã*rta:

it works well only if P is capital letter.
i want to accept p as capital as well as small letter.

pls help

"Stefi" wrote:

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?