Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
I'm looking for a function that will identify whether a cell contains all
text characters in uppercase, returning a true value if so and a false value if not. Does anything like this exist? |
#2
![]() |
|||
|
|||
![]()
Hi David,
=EXACT(A1,UPPER(A1)) -- Kind Regards, Niek Otten Microsoft MVP - Excel "David" wrote in message ... I'm looking for a function that will identify whether a cell contains all text characters in uppercase, returning a true value if so and a false value if not. Does anything like this exist? |
#3
![]() |
|||
|
|||
![]()
=EXACT(A1,UPPER(A1))
if I understand your requirements correctly. -- Vasant "David" wrote in message ... I'm looking for a function that will identify whether a cell contains all text characters in uppercase, returning a true value if so and a false value if not. Does anything like this exist? |
#4
![]() |
|||
|
|||
![]()
Nice one Niek,
Regards, "Niek Otten" wrote in message ... Hi David, =EXACT(A1,UPPER(A1)) -- Kind Regards, Niek Otten Microsoft MVP - Excel "David" wrote in message ... I'm looking for a function that will identify whether a cell contains all text characters in uppercase, returning a true value if so and a false value if not. Does anything like this exist? |
#5
![]() |
|||
|
|||
![]()
You're awesome. Thanks!
"Niek Otten" wrote: Hi David, =EXACT(A1,UPPER(A1)) -- Kind Regards, Niek Otten Microsoft MVP - Excel "David" wrote in message ... I'm looking for a function that will identify whether a cell contains all text characters in uppercase, returning a true value if so and a false value if not. Does anything like this exist? |
#6
![]() |
|||
|
|||
![]()
Vasant
You're too late. Niek got the "awesome" tag. Gord On Tue, 3 May 2005 13:30:24 -0400, "Vasant Nanavati" <vasantn *AT* aol *DOT* com wrote: =EXACT(A1,UPPER(A1)) if I understand your requirements correctly. |
#7
![]() |
|||
|
|||
![]()
Gord Dibben wrote...
Vasant You're too late. Niek got the "awesome" tag. .... Nice to be congratulated for repeating formulas that have been around for over a decade. Very little in these newsgroups is original. |
#8
![]() |
|||
|
|||
![]()
Darn, I'm always just missing the accolades! :(
-- Vasant "Gord Dibben" <gorddibbATshawDOTca wrote in message ... Vasant You're too late. Niek got the "awesome" tag. Gord On Tue, 3 May 2005 13:30:24 -0400, "Vasant Nanavati" <vasantn *AT* aol *DOT* com wrote: =EXACT(A1,UPPER(A1)) if I understand your requirements correctly. |
#9
![]() |
|||
|
|||
![]()
Thank you, Harlan
Sorry I just happened to be there at the "right" time -- Kind Regards, Niek Otten Microsoft MVP - Excel "Harlan Grove" wrote in message ups.com... Gord Dibben wrote... Vasant You're too late. Niek got the "awesome" tag. ... Nice to be congratulated for repeating formulas that have been around for over a decade. Very little in these newsgroups is original. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How can I convert entire columns of text to Uppercase in Excel? | Excel Worksheet Functions | |||
Sort or Filter option? | Excel Worksheet Functions | |||
Automatically change text to uppercase | Excel Worksheet Functions | |||
Read Text File into Excel Using VBA | Excel Discussion (Misc queries) | |||
How to change text in multiple cells from Uppercase to proper cas. | Excel Worksheet Functions |