» Identifying the Case of Letters within Strings
CATEGORY - Excel Text Formulas
VERSION - All Microsoft Excel Versions
Determining whether each of the names in List1 (column A) are exclusively upper case, exclusively lower case, or a combination of both.
Solution:
Use the IF, EXACT, UPPER, and LOWER functions as shown in the following formula:
=IF(EXACT(A2,UPPER(A2)),"Upper Case",IF(EXACT(A2,LOWER(A2)),"Lower Case","Upper and Lower Case"))
Book Store:
Recommended Books:
- Absolute Beginner's Guide to Microsoft Office Excel 2003
- What the IRS Doesn't Want You to Know: A Cpa Reveals the Tricks of the Trade
- Good to Great: Why Some Companies Make the Leap... and Others Don't
- Cashflow Quadrant: Rich Dad's Guide to Financial Freedom
- The 11 Immutable Laws of Internet Branding
- Financial Shenanigans : How to Detect Accounting Gimmicks & Fraud in Financial Reports
Letters within String
anoop
applied very good logic.
Simple formula
Would like to see an Example
DougStroud
Would be very beneficial to see how this formula is used and what results it generated.
Just what I needed
Tim McCarthy
Thank you. This is exactly what I was looking for!!
Just what I needed
Tim McCarthy
This is exactly what I was looking for. Thanks!!
I have no idea for what purposes this can be but I love it.
Frank