» Identifying the Case of Letters within Strings
CATEGORY - Excel Text Formulas
VERSION - All Microsoft Excel Versions
Problem: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:
- Financial Risk Manager Handbook, Second Edition
- The South Beach Diet: The Delicious, Doctor-Designed, Foolproof Plan for Fast and Healthy Weight Loss
- Harry Potter and the Order of the Phoenix (Book 5)
- Millionaire Real Estate Mentor : The Secrets of Financial Freedom through Real Estate Investing
- Microsoft Windows XP Inside Out
- Microsoft Excel Version 2002 Step by Step
No comments have been submitted.
