+ Reply to Thread
Results 1 to 6 of 6

Filter for strings containing only capital letters?

  1. #1
    Forum Contributor
    Join Date
    11-12-2014
    Location
    Boston, MA
    MS-Off Ver
    Office 2010
    Posts
    172

    Filter for strings containing only capital letters?

    Hi,
    I have a list containing names which came from multiple sources. All the names from one source came in as all CAPS, and I want to remove those. Is there any way I can filter so that I don't see any rows where the name is all CAPS?

    Thanks!

  2. #2
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    12,503

    Re: Filter for strings containing only capital letters?

    Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

    Remember to desensitize the data.

    Click on GO ADVANCED and use the paperclip icon to open the upload window.

    View Pic

  3. #3
    Forum Contributor
    Join Date
    11-12-2014
    Location
    Boston, MA
    MS-Off Ver
    Office 2010
    Posts
    172

    Re: Filter for strings containing only capital letters?

    Here you go. Pretty straight forward, just need to remove any of the names that are all uppercase
    Attached Files Attached Files

  4. #4
    Forum Guru shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,649

    Re: Filter for strings containing only capital letters?

    You could use a formula and the autofilter:

    Row\Col
    A
    B
    C
    1
    Current List
    Upper?
    2
    JACK
    1
    B2: =--EXACT(A2,UPPER(A2))
    3
    Jon
    0
    4
    JOE
    1
    5
    JILL
    1
    6
    Jeff
    0
    7
    JERRY
    1
    8
    Joan
    0
    9
    John
    0
    Entia non sunt multiplicanda sine necessitate

  5. #5
    Forum Contributor
    Join Date
    11-12-2014
    Location
    Boston, MA
    MS-Off Ver
    Office 2010
    Posts
    172

    Re: Filter for strings containing only capital letters?

    shg, you are a genius!

  6. #6
    Forum Guru shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,649

    Re: Filter for strings containing only capital letters?

    You're welcome.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Looking for a function whitch would filter just capital strings from a cell.
    By Alan248 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-29-2014, 01:36 AM
  2. Replies: 13
    Last Post: 07-08-2012, 11:26 PM
  3. Capital Letters
    By avveerkar in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-12-2008, 04:13 PM
  4. [SOLVED] Capital Letters
    By Gaute in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 03-09-2005, 06:06 AM

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