Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Validation Data using Validation Table cell range..... | Excel Discussion (Misc queries) | |||
Data Validation Update Validation Selection | Excel Worksheet Functions | |||
data validation invalid in dynamic validation list | Excel Discussion (Misc queries) | |||
data validation invalid in dynamic validation list | Excel Worksheet Functions | |||
Data validation with validation lists and combo boxs | Excel Discussion (Misc queries) |