| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
test for upper case
Is their a function or way to use the UPPER function to test if the contents
on a cell are all Upper case? Alternatively if someone has a macro to do so I could copy I would appreciate. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
test for upper case
To check A1, in another cell enter
=IF(EXACT(A1,UPPER(A1)),TRUE,FALSE) Copy as needed. Hope this helps, Hutch "MusicMan" wrote: Is their a function or way to use the UPPER function to test if the contents on a cell are all Upper case? Alternatively if someone has a macro to do so I could copy I would appreciate. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
test for upper case
Very close, but blanks also came back true. I can handle them in IF test
though. Thanks very much. "Tom Hutchins" wrote: To check A1, in another cell enter =IF(EXACT(A1,UPPER(A1)),TRUE,FALSE) Copy as needed. Hope this helps, Hutch "MusicMan" wrote: Is their a function or way to use the UPPER function to test if the contents on a cell are all Upper case? Alternatively if someone has a macro to do so I could copy I would appreciate. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
test for upper case
=IF(AND(LEN(TRIM(A1))0,EXACT(A1,UPPER(A1))),TRUE, FALSE)
-- Don Guillett Microsoft MVP Excel SalesAid Software "MusicMan" wrote in message ... Very close, but blanks also came back true. I can handle them in IF test though. Thanks very much. "Tom Hutchins" wrote: To check A1, in another cell enter =IF(EXACT(A1,UPPER(A1)),TRUE,FALSE) Copy as needed. Hope this helps, Hutch "MusicMan" wrote: Is their a function or way to use the UPPER function to test if the contents on a cell are all Upper case? Alternatively if someone has a macro to do so I could copy I would appreciate. |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
test for upper case
ABS(CODE(A1)-77.5)<13
|
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
test for upper case
Hi,
Try this =IF(A1<"",EXACT(A1,UPPER(A1))) -- If this helps, please click the Yes button. Cheers, Shane Devenshire "MusicMan" wrote: Very close, but blanks also came back true. I can handle them in IF test though. Thanks very much. "Tom Hutchins" wrote: To check A1, in another cell enter =IF(EXACT(A1,UPPER(A1)),TRUE,FALSE) Copy as needed. Hope this helps, Hutch "MusicMan" wrote: Is their a function or way to use the UPPER function to test if the contents on a cell are all Upper case? Alternatively if someone has a macro to do so I could copy I would appreciate. |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
test for upper case
You don't, of course, need the IF(...,TRUE,FALSE), because you've already
got a Boolean. =EXACT(A1,UPPER(A1)) will do. -- David Biddulph "Tom Hutchins" wrote in message ... To check A1, in another cell enter =IF(EXACT(A1,UPPER(A1)),TRUE,FALSE) Copy as needed. Hope this helps, Hutch "MusicMan" wrote: Is their a function or way to use the UPPER function to test if the contents on a cell are all Upper case? Alternatively if someone has a macro to do so I could copy I would appreciate. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| convert lower to upper case automatically without using UPPER | Excel Discussion (Misc queries) | |||
| Changing upper case characters to upper/lower | Excel Discussion (Misc queries) | |||
| Defaulting test to Upper case | Excel Worksheet Functions | |||
| Changing file in all upper case to upper and lower case | Excel Discussion (Misc queries) | |||
| How do I convert all upper case excel sheet into upper and lower . | Excel Discussion (Misc queries) | |||
Linear Mode
