|
» Identifying the Case of Letters within Strings
CATEGORY: Excel Text Formulas |
VERSIONS: 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")) |
|
RATING:
1.87
VIEWS: 8739 |
||||
Letters within String
anoop wrote on October 28, 2005 23:35 EST
applied very good logic.
Simple formula
Would like to see an Example
DougStroud wrote on December 31, 1969 19:00 EST
Would be very beneficial to see how this formula is used and what results it generated.
Just what I needed
Tim McCarthy wrote on December 31, 1969 19:00 EST
Thank you. This is exactly what I was looking for!!
Just what I needed
Tim McCarthy wrote on December 31, 1969 19:00 EST
This is exactly what I was looking for. Thanks!!
Sponsors:
 |
Book Store:
Recommended Books:
- Word 2002: The Complete Reference
- Business Plans For Dummies®
- The Complete Book of Business Plans: Simple Steps to Writing a Powerful Business Plan (Small Business Sourcebooks)
- Absolute Beginner's Guide to Microsoft Office Excel 2003
- Business Analysis with Microsoft Excel (2nd Edition)
- The Ernst & Young Business Plan Guide
Related MS EXCEL TIPS:
Terms
and Conditions of use
The applications/code on this site are distributed as is and without warranties
or liability. In no event shall the owner of the copyrights, or the authors
of the applications/code be liable for any loss of profit, any problems
or any damage resulting from the use or evaluation of the applications/code.
I have no idea for what purposes this can be but I love it.
Frank