| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conversion of Numercials to Figure | Excel Worksheet Functions | |||
| EXCEL:NUMBER TO GREEK WORDS | Excel Worksheet Functions | |||
| reminder notifications in a column | Excel Discussion (Misc queries) | |||
| convert value in word. For Exampe Rs.115.00 convert into word as . | Excel Discussion (Misc queries) | |||
| Amount or Numbers in Words | New Users to Excel | |||
Threaded Mode
