+ Reply to Thread
Results 1 to 6 of 6

Filter for strings containing only capital letters?

  1. 12-17-2014, 05:50 PM #1
    AstToTheRegionalMGR
    AstToTheRegionalMGR is offline
    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!
    Reply With QuoteRegister To Reply
  2. 12-17-2014, 05:52 PM #2
    davesexcel
    davesexcel is offline
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,480

    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
    ,
    Xlorate.com, Selection Codes, YouYube Channel
    Reply With QuoteRegister To Reply
  3. 12-17-2014, 05:59 PM #3
    AstToTheRegionalMGR
    AstToTheRegionalMGR is offline
    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
    Reply With QuoteRegister To Reply
  4. 12-17-2014, 06:37 PM #4
    shg
    shg is offline
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    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
    Reply With QuoteRegister To Reply
  5. 12-18-2014, 11:58 AM #5
    AstToTheRegionalMGR
    AstToTheRegionalMGR is offline
    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!
    Reply With QuoteRegister To Reply
  6. 12-18-2014, 02:01 PM #6
    shg
    shg is offline
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: Filter for strings containing only capital letters?

    You're welcome.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next 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. Excel 2008 : Formula to remove consecutive capital letters from text strings
    By JesseG123 in forum Excel General
    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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1