| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel,microsoft.public.excel.worksheet.functions
|
|||
|
|||
getting XL to recognize lower from upper case in IF formula
Thanks.
Actually, come to think of it, if I could have a formula that does if 3 letter of D3 is lower case, then divide by 50--that would be the best. Is there a way to define "lower case" in 3rd position? Niek Otten wrote: Use the EXACT() function |
|
#2
Posted to microsoft.public.excel,microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
getting XL to recognize lower from upper case in IF formula
=IF(EXACT(MID(A1,3,1),LOWER(MID(A1,3,1))),"lower", "upper")
-- Jim "stef" wrote in message ... | Thanks. | Actually, come to think of it, if I could have a formula that does if 3 | letter of D3 is lower case, then divide by 50--that would be the best. | Is there a way to define "lower case" in 3rd position? | | Niek Otten wrote: | Use the EXACT() function | |
|
#3
Posted to microsoft.public.excel,microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
getting XL to recognize lower from upper case in IF formula
Thanks
Jim Rech wrote: =IF(EXACT(MID(A1,3,1),LOWER(MID(A1,3,1))),"lower", "upper") |
|
#4
Posted to microsoft.public.excel.worksheet.functions,microsoft.public.excel
|
|||
|
|||
|
getting XL to recognize lower from upper case in IF formula
You could use something like this:
=IF(CODE(MID(D3,3,1))<=90,"Upper","Lower") Where you'd replace "Upper" with what you want it to do if the 3rd character is upper case and replace "Lower" with what you want it to do if the 3rd character is lower case. This assumes that the 3rd character will always be an alpha character (no numbers or special symbols) and that your computer is using standard ASCII character set. Hope that helps. -- Mike Lee McKinney,TX USA "stef" wrote: Thanks. Actually, come to think of it, if I could have a formula that does if 3 letter of D3 is lower case, then divide by 50--that would be the best. Is there a way to define "lower case" in 3rd position? Niek Otten wrote: Use the EXACT() function |
|
#5
Posted to microsoft.public.excel.worksheet.functions,microsoft.public.excel
|
|||
|
|||
|
getting XL to recognize lower from upper case in IF formula
That's good, (only letters no numbers or symbols in 3rd position). I
will try it. Tx. mikelee101 wrote: You could use something like this: =IF(CODE(MID(D3,3,1))<=90,"Upper","Lower") Where you'd replace "Upper" with what you want it to do if the 3rd character is upper case and replace "Lower" with what you want it to do if the 3rd character is lower case. This assumes that the 3rd character will always be an alpha character (no numbers or special symbols) and that your computer is using standard ASCII character set. Hope that helps. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Changing file in all upper case to upper and lower case | Excel Discussion (Misc queries) | |||
| upper\lower case formula problem | Excel Discussion (Misc queries) | |||
| Change from mixed caps and upper lower to all upper lower case | Excel Worksheet Functions | |||
| Formula to identify lower case vs upper case | Excel Worksheet Functions | |||
| How do I convert all upper case excel sheet into upper and lower . | Excel Discussion (Misc queries) | |||
Hybrid Mode
