How do I search with Excel for cells with specific characters at the end of the string?











up vote
0
down vote

favorite












I need to know how to use pattern matching in excel.



Suppose I have 3 cells...



ABC



ABD



JGFC



I need to highlight those with C AT THE END.



This is a small example. I need to do similar stuff for hundreds of cells. It's very frustrating and sometimes I'll miss several. I need a fast and reliable way.










share|improve this question
























  • When you say "highlight", do you mean you need to format them or you need to select them?
    – Worthwelle
    Nov 15 at 17:11















up vote
0
down vote

favorite












I need to know how to use pattern matching in excel.



Suppose I have 3 cells...



ABC



ABD



JGFC



I need to highlight those with C AT THE END.



This is a small example. I need to do similar stuff for hundreds of cells. It's very frustrating and sometimes I'll miss several. I need a fast and reliable way.










share|improve this question
























  • When you say "highlight", do you mean you need to format them or you need to select them?
    – Worthwelle
    Nov 15 at 17:11













up vote
0
down vote

favorite









up vote
0
down vote

favorite











I need to know how to use pattern matching in excel.



Suppose I have 3 cells...



ABC



ABD



JGFC



I need to highlight those with C AT THE END.



This is a small example. I need to do similar stuff for hundreds of cells. It's very frustrating and sometimes I'll miss several. I need a fast and reliable way.










share|improve this question















I need to know how to use pattern matching in excel.



Suppose I have 3 cells...



ABC



ABD



JGFC



I need to highlight those with C AT THE END.



This is a small example. I need to do similar stuff for hundreds of cells. It's very frustrating and sometimes I'll miss several. I need a fast and reliable way.







microsoft-excel microsoft-excel-2016






share|improve this question















share|improve this question













share|improve this question




share|improve this question








edited Nov 15 at 17:40









Mureinik

2,20351525




2,20351525










asked Nov 15 at 16:29









Nabeel Parkar

334




334












  • When you say "highlight", do you mean you need to format them or you need to select them?
    – Worthwelle
    Nov 15 at 17:11


















  • When you say "highlight", do you mean you need to format them or you need to select them?
    – Worthwelle
    Nov 15 at 17:11
















When you say "highlight", do you mean you need to format them or you need to select them?
– Worthwelle
Nov 15 at 17:11




When you say "highlight", do you mean you need to format them or you need to select them?
– Worthwelle
Nov 15 at 17:11










1 Answer
1






active

oldest

votes

















up vote
3
down vote



accepted










For this specific example, you can use =RIGHT(A1,1)="C".



Depending on how similar your other use cases are, you may also want to look into the LEFT(), MID() and FIND() formulae. For complex pattern matching, you may need to resort to VBA to implement a regex-based match.






share|improve this answer





















    Your Answer








    StackExchange.ready(function() {
    var channelOptions = {
    tags: "".split(" "),
    id: "3"
    };
    initTagRenderer("".split(" "), "".split(" "), channelOptions);

    StackExchange.using("externalEditor", function() {
    // Have to fire editor after snippets, if snippets enabled
    if (StackExchange.settings.snippets.snippetsEnabled) {
    StackExchange.using("snippets", function() {
    createEditor();
    });
    }
    else {
    createEditor();
    }
    });

    function createEditor() {
    StackExchange.prepareEditor({
    heartbeatType: 'answer',
    convertImagesToLinks: true,
    noModals: true,
    showLowRepImageUploadWarning: true,
    reputationToPostImages: 10,
    bindNavPrevention: true,
    postfix: "",
    imageUploader: {
    brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
    contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
    allowUrls: true
    },
    onDemand: true,
    discardSelector: ".discard-answer"
    ,immediatelyShowMarkdownHelp:true
    });


    }
    });














     

    draft saved


    draft discarded


















    StackExchange.ready(
    function () {
    StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsuperuser.com%2fquestions%2f1375738%2fhow-do-i-search-with-excel-for-cells-with-specific-characters-at-the-end-of-the%23new-answer', 'question_page');
    }
    );

    Post as a guest















    Required, but never shown

























    1 Answer
    1






    active

    oldest

    votes








    1 Answer
    1






    active

    oldest

    votes









    active

    oldest

    votes






    active

    oldest

    votes








    up vote
    3
    down vote



    accepted










    For this specific example, you can use =RIGHT(A1,1)="C".



    Depending on how similar your other use cases are, you may also want to look into the LEFT(), MID() and FIND() formulae. For complex pattern matching, you may need to resort to VBA to implement a regex-based match.






    share|improve this answer

























      up vote
      3
      down vote



      accepted










      For this specific example, you can use =RIGHT(A1,1)="C".



      Depending on how similar your other use cases are, you may also want to look into the LEFT(), MID() and FIND() formulae. For complex pattern matching, you may need to resort to VBA to implement a regex-based match.






      share|improve this answer























        up vote
        3
        down vote



        accepted







        up vote
        3
        down vote



        accepted






        For this specific example, you can use =RIGHT(A1,1)="C".



        Depending on how similar your other use cases are, you may also want to look into the LEFT(), MID() and FIND() formulae. For complex pattern matching, you may need to resort to VBA to implement a regex-based match.






        share|improve this answer












        For this specific example, you can use =RIGHT(A1,1)="C".



        Depending on how similar your other use cases are, you may also want to look into the LEFT(), MID() and FIND() formulae. For complex pattern matching, you may need to resort to VBA to implement a regex-based match.







        share|improve this answer












        share|improve this answer



        share|improve this answer










        answered Nov 15 at 16:39









        jsheeran

        1712




        1712






























             

            draft saved


            draft discarded



















































             


            draft saved


            draft discarded














            StackExchange.ready(
            function () {
            StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsuperuser.com%2fquestions%2f1375738%2fhow-do-i-search-with-excel-for-cells-with-specific-characters-at-the-end-of-the%23new-answer', 'question_page');
            }
            );

            Post as a guest















            Required, but never shown





















































            Required, but never shown














            Required, but never shown












            Required, but never shown







            Required, but never shown

































            Required, but never shown














            Required, but never shown












            Required, but never shown







            Required, but never shown







            Popular posts from this blog

            Сан-Квентин

            Алькесар

            Josef Freinademetz