+ Reply to Thread
Results 1 to 3 of 3

Search For Combination / Sequence of Uppercase & Lowercase Characters / Wildcards

  1. #1
    Registered User
    Join Date
    01-16-2014
    Location
    London, England
    MS-Off Ver
    Office 365
    Posts
    25

    Search For Combination / Sequence of Uppercase & Lowercase Characters / Wildcards

    Hi,

    Is there a way to search for a specific sequence / combination of uppercase and lowercase characters within a string?

    I want to search for the substring " and UU", "UUU of " and "###) of" within a string, where "U" indicates an uppercase letter, and "#" indicates a number.

    I don't believe I can use InStr, as this doesn't accept wildcards. And as far as I'm aware, the Like operator is not case sensitive.

    Cheers

  2. #2
    Forum Expert
    Join Date
    02-11-2014
    Location
    New York
    MS-Off Ver
    Excel 365 (Windows)
    Posts
    5,912

    Re: Search For Combination / Sequence of Uppercase & Lowercase Characters / Wildcards

    You can do that using REGEX - at which I stink, but there are plenty of resources online.
    Bernie Deitrick
    Excel MVP 2000-2010

  3. #3
    Forum Expert
    Join Date
    10-11-2021
    Location
    Netherlands
    MS-Off Ver
    365
    Posts
    1,367

    Re: Search For Combination / Sequence of Uppercase & Lowercase Characters / Wildcards

    Here a Regex

    Please Login or Register  to view this content.

+ 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. Uppercase to Lowercase
    By Mattsmash in forum Excel General
    Replies: 4
    Last Post: 11-04-2019, 06:43 PM
  2. [SOLVED] lowercase - uppercase
    By max_max in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 11-08-2013, 05:29 PM
  3. UPPERCASE to lowercase
    By ericinarcata in forum Excel General
    Replies: 7
    Last Post: 01-09-2012, 11:41 PM
  4. Uppercase = (This) Lowercase = (That)
    By uscoobyk in forum Excel General
    Replies: 4
    Last Post: 09-27-2010, 08:54 AM
  5. uppercase to lowercase
    By Ltat42a in forum Excel General
    Replies: 7
    Last Post: 02-02-2007, 08:51 AM
  6. uppercase to lowercase
    By Missy in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-03-2005, 06:06 PM
  7. [SOLVED] lowercase to uppercase
    By Louise in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 01-10-2005, 06:06 PM

Tags for this Thread

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