+ 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
    Forum Expert torachan's Avatar
    Join Date
    12-27-2012
    Location
    market harborough, england
    MS-Off Ver
    Excel 2010
    Posts
    4,295

    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
    Forum Expert torachan's Avatar
    Join Date
    12-27-2012
    Location
    market harborough, england
    MS-Off Ver
    Excel 2010
    Posts
    4,295

    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
    Microsoft 365, Office 2007, 2010 & 2016
    Posts
    23

    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)

Similar Threads

  1. [SOLVED] =SUM Combination In Order To Find Specific Value For Large Amount of Data
    By KMVKMVKMV in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 05-02-2017, 04:17 PM
  2. Macro to FIND first cell in column A beginning with a specific letter.
    By WISHiKNEW in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-05-2015, 11:52 AM
  3. Format issue with changing a number letter combination to a date
    By Newbiedine in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 09-13-2014, 01:34 AM
  4. Need Validation formula for a Letter Number Combination
    By Talo in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 11-19-2012, 12:22 PM
  5. [SOLVED] Find specific data combination on another sheet using command button.
    By Ataraxicatom in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 09-08-2012, 09:55 AM
  6. [SOLVED] How do I find a cell starting with a specific letter?
    By Bking in forum Excel General
    Replies: 5
    Last Post: 07-18-2005, 01:05 AM
  7. [SOLVED] Find column letter containing specific data
    By markx in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 03-17-2005, 07:06 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