# Find data (cell) with specific letter and number combination

1. ## 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.

2. ## 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:
`Please Login or Register  to view this content.`

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

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

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

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

Originally Posted by torachan
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. ## 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. ## Re: Find data (cell) with specific letter and number combination

Originally Posted by torachan
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. ## Re: Find data (cell) with specific letter and number combination

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

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

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

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

Hi,

You can try the following code:

Formula:
`Please Login or Register  to view this content.`

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

#### 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