| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
letter case?
How might I create an IF formula to recognize whether text in a column is
lower or upper case so that the text-related values may be added or subtracted based on the case of the text? For example, I have text in B1:B50 whose complimenting values I would like to + or - from the values attributed to the text in D1:D50 depending on the case of that text. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
letter case?
If there is a single character in A1 then:
=IF(AND(CODE(A1)64,CODE(A1)<91),"upper","lower") -- Gary's Student "pacent" wrote: How might I create an IF formula to recognize whether text in a column is lower or upper case so that the text-related values may be added or subtracted based on the case of the text? For example, I have text in B1:B50 whose complimenting values I would like to + or - from the values attributed to the text in D1:D50 depending on the case of that text. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
letter case?
You can test it like so
=EXACT(B1,LOWER(B1)) or =EXACT(B1,UPPER(B1)) -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "pacent" wrote in message ... How might I create an IF formula to recognize whether text in a column is lower or upper case so that the text-related values may be added or subtracted based on the case of the text? For example, I have text in B1:B50 whose complimenting values I would like to + or - from the values attributed to the text in D1:D50 depending on the case of that text. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
letter case?
How about for all caps?
"Gary''s Student" wrote: If there is a single character in A1 then: =IF(AND(CODE(A1)64,CODE(A1)<91),"upper","lower") -- Gary's Student "pacent" wrote: How might I create an IF formula to recognize whether text in a column is lower or upper case so that the text-related values may be added or subtracted based on the case of the text? For example, I have text in B1:B50 whose complimenting values I would like to + or - from the values attributed to the text in D1:D50 depending on the case of that text. |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
letter case?
Allow me to clarify my ? -- the text is ALL CAPS vs Capitalized (not entirely
lower case). Is it possible? "Gary''s Student" wrote: If there is a single character in A1 then: =IF(AND(CODE(A1)64,CODE(A1)<91),"upper","lower") -- Gary's Student "pacent" wrote: How might I create an IF formula to recognize whether text in a column is lower or upper case so that the text-related values may be added or subtracted based on the case of the text? For example, I have text in B1:B50 whose complimenting values I would like to + or - from the values attributed to the text in D1:D50 depending on the case of that text. |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
letter case?
Bob Phillips has the correct approach:
=IF(EXACT(A1,UPPER(A1)),"all upper",IF(EXACT(A1,LOWER(A1)),"all lower","mixed")) -- Gary's Student "pacent" wrote: Allow me to clarify my ? -- the text is ALL CAPS vs Capitalized (not entirely lower case). Is it possible? "Gary''s Student" wrote: If there is a single character in A1 then: =IF(AND(CODE(A1)64,CODE(A1)<91),"upper","lower") -- Gary's Student "pacent" wrote: How might I create an IF formula to recognize whether text in a column is lower or upper case so that the text-related values may be added or subtracted based on the case of the text? For example, I have text in B1:B50 whose complimenting values I would like to + or - from the values attributed to the text in D1:D50 depending on the case of that text. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| VBA Code | Excel Discussion (Misc queries) | |||
| convert numbers to text | Excel Discussion (Misc queries) | |||
| reminder notifications in a column | Excel Discussion (Misc queries) | |||
| Spellnumber | Excel Worksheet Functions | |||
| Identifying the Active Fill Color | Excel Discussion (Misc queries) | |||
Linear Mode
