I need to find cells that ONLY contain a "1" at a certain position

[abarbee314]

I don't know if my solution will require a macro or not. I can use macros, but don't know how to write them. At any rate, here's my scenario: I've got nearly 3800 rows of part numbers and I need to only see/use the ones that have a 1 at the 8th position. All part numbers are 14 characters long, if that matters. But, the only ones I need to see or use are those with a 1 in that position.

I don't need to count them, remove the characters, or anything. I need to either highlight those cells with a 1 in the right spot (so I can copy/paste them out) or exclude the others that don't match this search. I have additional work I need to do with the part numbers, but only after I can focus on the correct ones.

Any thoughts? Thanks, in advance, for your help (as always!).

 

[Robert Mika]

You can use this as conditional formatting
=--MID($A1,8,1)=1

the copy the format down.

 

[eliW]

Hi
In another column enter the formula: =MID(C2,8,1)=1 and copy down
Where your part number is in column C.
HTH
Robert MIKA is right: you have to add -- in order to make the reesult a VALUE and not TEXT

 

[abarbee314]

Robert: thank you VERY MUCH for the quick reply. I adjusted the cell position (my data was in B2) and got your conditional formatting suggestion to work. This made it pretty easy to figure out which cells to delete.

Thanks again.