+ Reply to Thread
Results 1 to 10 of 10

Find data (cell) with specific letter and number combination

  1. #1
    Registered User
    Join Date
    10-20-2010
    Location
    MD
    MS-Off Ver
    Excel 2003
    Posts
    53

    Find data (cell) with specific letter and number combination

    Hi all,

    I need to find the cells that have specific letter and number combination. So the cell must have: First letter, then 3 numbers and at the end another 2 letter. Can someone help me with this one?

    This are the number and letter combination I'm looking for:

    T773MK
    T676EP
    A947EH

    Excel file attached.

    Thank you.
    Attached Files Attached Files

  2. #2
    Forum Expert kersplash's Avatar
    Join Date
    11-22-2016
    Location
    Perth
    MS-Off Ver
    Home 2016 (Windows 10)/Work 2013 Pro Plus (Windows 10)
    Posts
    2,012

    Re: Find data (cell) with specific letter and number combination

    You could apply this formula as a conditional format to the A:A column and then filter on the coloured cells;
    Formula: copy to clipboard
    Please Login or Register  to view this content.

  3. #3
    Valued Forum Contributor
    Join Date
    12-27-2012
    Location
    market harborough, england
    MS-Off Ver
    Excel 2010
    Posts
    736

    Re: Find data (cell) with specific letter and number combination

    Try the attached.
    Enter in box, press search, should then scroll to row.
    torachan.
    Attached Files Attached Files

  4. #4
    Registered User
    Join Date
    10-20-2010
    Location
    MD
    MS-Off Ver
    Excel 2003
    Posts
    53

    Re: Find data (cell) with specific letter and number combination

    Quote Originally Posted by kersplash View Post
    You could apply this formula as a conditional format to the A:A column and then filter on the coloured cells;
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Thank you, but I get an error when trying to apply the code:
    Attachment 624500

    Quote Originally Posted by torachan View Post
    Try the attached.
    Enter in box, press search, should then scroll to row.
    torachan.
    What should I do with the search box? Sorry, I cannot understand.

  5. #5
    Valued Forum Contributor
    Join Date
    12-27-2012
    Location
    market harborough, england
    MS-Off Ver
    Excel 2010
    Posts
    736

    Re: Find data (cell) with specific letter and number combination

    Type in the box to the left of the 'SEARCH' button what you are searching for (e.g. T773MK)
    Ensure the entry is precise, i.e. Uppercase/Lower case correct, space/nospaces etc.
    Press 'SEARCH' !bingo!, if it cannot find anything you will get a message box saying so.
    torachan.

  6. #6
    Registered User
    Join Date
    10-20-2010
    Location
    MD
    MS-Off Ver
    Excel 2003
    Posts
    53

    Re: Find data (cell) with specific letter and number combination

    Quote Originally Posted by torachan View Post
    Type in the box to the left of the 'SEARCH' button what you are searching for (e.g. T773MK)
    Ensure the entry is precise, i.e. Uppercase/Lower case correct, space/nospaces etc.
    Press 'SEARCH' !bingo!, if it cannot find anything you will get a message box saying so.
    torachan.
    Thank you for your help bu I think you didn't understand my question. I need to find all the number and letter combination that has first letter then 3 numbers and at the end 2 letters.

  7. #7
    Forum Expert kersplash's Avatar
    Join Date
    11-22-2016
    Location
    Perth
    MS-Off Ver
    Home 2016 (Windows 10)/Work 2013 Pro Plus (Windows 10)
    Posts
    2,012

    Re: Find data (cell) with specific letter and number combination

    My option is a conditional format applied to Column A, not a formula.

  8. #8
    Registered User
    Join Date
    10-20-2010
    Location
    MD
    MS-Off Ver
    Excel 2003
    Posts
    53

    Re: Find data (cell) with specific letter and number combination

    Quote Originally Posted by kersplash View Post
    My option is a conditional format applied to Column A, not a formula.
    Did you see the error in the attachment?

  9. #9
    Forum Expert kersplash's Avatar
    Join Date
    11-22-2016
    Location
    Perth
    MS-Off Ver
    Home 2016 (Windows 10)/Work 2013 Pro Plus (Windows 10)
    Posts
    2,012

    Re: Find data (cell) with specific letter and number combination

    Can't download the attachment (website error).

  10. #10
    Registered User
    Join Date
    03-25-2013
    Location
    Srinagar, JK, India
    MS-Off Ver
    Office 2007, 2010, & 2016
    Posts
    17

    Re: Find data (cell) with specific letter and number combination

    Hi,

    You can try the following code:

    Formula: copy to clipboard
    Please Login or Register  to view this content.
    With regards,
    Mullah Raheil.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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