+ Reply to Thread
Results 1 to 4 of 4

How do I filter cells with based on specific symbols in the middle of text

  1. #1
    Registered User
    Join Date
    12-21-2014
    Location
    Gainesville, Georgia
    MS-Off Ver
    2010
    Posts
    7

    How do I filter cells with based on specific symbols in the middle of text

    I have Cells that have nonspecific symbols in the middle of the text, and would like to filter and reorder the cells based on the text in the middle.
    If names got reformatted like such, but where scattered about in a long list of names, how would I go about finding them.
    bobjsmith
    johnklogan
    georgewbush
    michaelsbuble
    michaeljjackson

    Is there a way to format the filter to say ""j"" gets highlighted or changed to bob j smith

    Thank you in advance.

  2. #2
    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: How do I filter cells with based on specific symbols in the middle of text

    Row\Col
    A
    B
    C
    2
    bobjsmith bob j smith B2:=IFERROR(REPLACE(A2, SEARCH("j", A2, 2), 1, " j "), A2)
    3
    johnklogan johnklogan
    4
    georgewbush georgewbush
    5
    michaelsbuble michaelsbuble
    6
    michaeljjackson michael j jackson
    Entia non sunt multiplicanda sine necessitate

  3. #3
    Registered User
    Join Date
    12-21-2014
    Location
    Gainesville, Georgia
    MS-Off Ver
    2010
    Posts
    7

    Re: How do I filter cells with based on specific symbols in the middle of text

    What does exactly does that do? Iferror, does that mean excel is looking for an error in the code or text to fix?

  4. #4
    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: How do I filter cells with based on specific symbols in the middle of text

    Select B2, Formulas tab > Evaluate Formula button. You'll see what it does.

+ 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. vba macro filter based on a array of cells with text and number values
    By daviddg in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-24-2014, 04:39 AM
  2. Create symbols based on text input
    By DHirsch in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-08-2013, 06:39 PM
  3. [SOLVED] Need to Generate Symbols Based on Text for Task List
    By DHirsch in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 03-08-2013, 02:35 PM
  4. Cut and paste cells based on specific text
    By on top in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-11-2010, 06:58 PM
  5. How to filter a range of cells for specific text?
    By talk2mide in forum Excel General
    Replies: 2
    Last Post: 03-01-2007, 05:35 PM

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