+ Reply to Thread
Results 1 to 6 of 6

Identifying the Case of Letters within Strings

  1. #1
    DougStroud
    Guest

    Would like to see an Example

    Would be very beneficial to see how this formula is used and what results it generated.

  2. #2
    Tim McCarthy
    Guest

    Just what I needed

    Thank you. This is exactly what I was looking for!!

  3. #3
    Tim McCarthy
    Guest

    Just what I needed

    This is exactly what I was looking for. Thanks!!

  4. #4
    Forum Contributor
    Join Date
    12-07-2004
    Posts
    596

    Identifying the Case of Letters within Strings

    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\"))

  5. #5
    Registered User
    Join Date
    09-03-2003
    Location
    Germany
    Posts
    2

    Red face Identifying the Case of Letters within Strings

    This is crazy but great!
    I have no idea for what purposes this can be but I love it.

    Frank
    Frank
    frank.beuken@cardinal.com

  6. #6
    Registered User
    Join Date
    11-24-2003
    Location
    UAE
    Posts
    6

    Letters within String

    applied very good logic.
    Simple formula

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1