Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
David
 
Posts: n/a
Default Identify text in uppercase

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   Report Post  
Niek Otten
 
Posts: n/a
Default

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   Report Post  
Vasant Nanavati
 
Posts: n/a
Default

=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   Report Post  
Alan
 
Posts: n/a
Default

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   Report Post  
David
 
Posts: n/a
Default

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   Report Post  
Gord Dibben
 
Posts: n/a
Default

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   Report Post  
Harlan Grove
 
Posts: n/a
Default

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   Report Post  
Vasant Nanavati
 
Posts: n/a
Default

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   Report Post  
Niek Otten
 
Posts: n/a
Default

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How can I convert entire columns of text to Uppercase in Excel? dplantlady Excel Worksheet Functions 8 May 1st 05 07:51 PM
Sort or Filter option? Mcobra41 Excel Worksheet Functions 3 February 23rd 05 08:22 PM
Automatically change text to uppercase Santie Excel Worksheet Functions 1 February 22nd 05 06:20 PM
Read Text File into Excel Using VBA Willie T Excel Discussion (Misc queries) 13 January 8th 05 01:37 AM
How to change text in multiple cells from Uppercase to proper cas. Excel help Excel Worksheet Functions 1 November 17th 04 04:45 AM


All times are GMT +1. The time now is 06:01 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"