» 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:
- VBA for Modelers: Developing Decision Support Systems Using Microsoft« Excel
- Microsoft Excel 2002 Formulas (With CD-ROM)
- Keys to Reading an Annual Report (Barron's Business Keys)
- Microsoft Office XP Introductory Concepts and Techniques
- F1 Get the Most out of Excel! The Ultimate Excel tip Help Guide
- The 22 Immutable Laws of Branding
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