Formula to identify lower case vs upper case
 

(A2)=IF(ISNUMBER(SEARCH("n",W2)),"Y")

THIS WILL PUT A "Y" IN CELL A2 IF THERE IN AN "n" (upper or lower case) in
cell W2.
I need it to put a Y in cell AS only if there is a lower case n in cell W2.
This is Excel 2003

Thanks for the help!

Formula to identify lower case vs upper case
 

SEARCH and SEARCHB are not case sensitive. If you want to do a case sensitive
search, you can use FIND and FINDB.

=IF(ISNUMBER(FIND("n",W2)),"Y")
--
Gary's Student


"laralea" wrote:

(A2)=IF(ISNUMBER(SEARCH("n",W2)),"Y")

THIS WILL PUT A "Y" IN CELL A2 IF THERE IN AN "n" (upper or lower case) in
cell W2.
I need it to put a Y in cell AS only if there is a lower case n in cell W2.
This is Excel 2003

Thanks for the help!

Formula to identify lower case vs upper case
 

=IF(CODE(W2)=110,"Y","else no another value")

"laralea" wrote:

(A2)=IF(ISNUMBER(SEARCH("n",W2)),"Y")

THIS WILL PUT A "Y" IN CELL A2 IF THERE IN AN "n" (upper or lower case) in
cell W2.
I need it to put a Y in cell AS only if there is a lower case n in cell W2.
This is Excel 2003

Thanks for the help!

Formula to identify lower case vs upper case
 

Here's another one:

=IF(EXACT(W2,"n"),"Y","")

Biff

"laralea" wrote in message
...
(A2)=IF(ISNUMBER(SEARCH("n",W2)),"Y")

THIS WILL PUT A "Y" IN CELL A2 IF THERE IN AN "n" (upper or lower case) in
cell W2.
I need it to put a Y in cell AS only if there is a lower case n in cell
W2.
This is Excel 2003

Thanks for the help!