» 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:
- Microsoft Office XP Step-By-Step (With CD-ROM)
- MP Managerial Accounting w/ Topic Tackler, Net Tutor, & PowerWeb
- Managing by the Numbers: A Commonsense Guide to Understanding and Using Your Company's Financials: An Essential Resource for Growing Businesses
- The South Beach Diet: The Delicious, Doctor-Designed, Foolproof Plan for Fast and Healthy Weight Loss
- How to Use Financial Statements: A Guide to Understanding the Numbers
- Advanced modelling in finance using Excel and VBA
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