Detecting Case of Text in a Cell

  • Thread starter Thread starter Colin Vicary
  • Start date Start date
C

Colin Vicary

Hi All

I know it's possible to change the case of text in a cell in Excel
using Lower, Upper and Proper, but is there a function that tells me
the current case of the text?

A user has a spreadsheet of catalogue items, some in proper case and
some in upper. He wants to seperate those in upper case into a separate
sheet but I can't think of an easy way of doing it.

Can anyone help?

Colin
 
I'd use a column with cells containing a formula like:

=IF(EXACT(A1,UPPER(A1)),"Upper",IF(EXACT(A1,LOWER(A1)),"Lower",
IF(EXACT(A1,PROPER(A1)),"Proper","somethingelse")))

(all one cell)

Then just filter on that column.

Be aware that 1234 will be treated as Upper--same with empty cells.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formatting cells to only upper case 5
convert lower to upper case automatically without using UPPER 6
Excel: how to convert text to upper case upon entry? 13
CHANGE LOWER CASE TO UPPER CASE? 1
Format Cell - Only Upper Case Alpha characters 3
Restrictions in format 1
How to change case of text without using functions? 3
Changing multiple cell text from lower case to upper case 2

Back
Top