+ Reply to Thread
Results 1 to 3 of 3

How to filter text that contains an asterisk *

  1. #1
    Registered User
    Join Date
    10-26-2013
    Location
    Melbourne, Australia
    MS-Off Ver
    Excel 2016
    Posts
    56

    How to filter text that contains an asterisk *

    Hello,

    I have a list of names I need to filter, some names contain an asterisk and some don't. I need to filter the ones that do..

    I'm going through regular channels of Data > Filter > Text filter > Ends with, however Excel has an exception for the asterisk to represent any character, which renders my filter useless!

    I've tried search engines, searching these forums, but it always seems to be filtered out so I can't get a result. Anybody know what to do in this situation?

    Thanks!

  2. #2
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2504
    Posts
    13,621

    Re: How to filter text that contains an asterisk *

    In the text box for "Ends with" an asterisk alone will not work but preceded by a tilde it does. So, enter ~* and the filter will work

  3. #3
    Registered User
    Join Date
    10-26-2013
    Location
    Melbourne, Australia
    MS-Off Ver
    Excel 2016
    Posts
    56

    Re: How to filter text that contains an asterisk *

    Oh thanks so much! It's incredibly simple if you know it. I had been using quotations which messed up everything.

    Thank you!

+ 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. Text box with asterisk border on top and bottom?
    By leaning in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-14-2010, 07:24 AM
  2. SUMPRODUCT contains text, using asterisk
    By commander1 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-09-2009, 04:23 PM
  3. Replies: 9
    Last Post: 06-19-2009, 03:38 PM
  4. [SOLVED] asterisk in a cell
    By Caroline41 in forum Excel General
    Replies: 2
    Last Post: 11-30-2005, 01:35 PM
  5. Replies: 12
    Last Post: 09-12-2005, 01:05 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