Formula to find a specific character in a cell

[yr25]

Here's the scenario: the part number is normally 6 digits long, sometimes the part number will be listed in this column again with an alpha character "D" at the end of the of the part number.

I'm looking to find all the rows where there's a "D" in the 7th position. These are the duplicate records that need to be removed.

Here's an example:

Column A, Row 1 has part# 123456
Column A, Row 2 has part# 123456D

In Column B I would like create a flag or indicator highlighting all rows that have a "D" after the 6 digits because I will need to remove those rows.

Column A may have other part numbers in different formats lbut basically the 7th position will have a "D" and these rows need to be identified.

What formula can I write that will capture this?

Thank you for reviewing this, I hope I explained what I need

[icestationzbra]

put this is B1 and drag down. wherever you see TRUE, the neighbouring cell in Column A has letter "D" in 7th position:

Please Login or Register  to view this content.

you could also use this in the Conditional Formatting rules to highlight cells which have "D" in the 7th position.

[Ace_XL]

Try in another column

=IF(MID(B1,7,1)="D","delete","")

Filter on "delete" and delete rows

[Cutter]

You could highlight the range and do Ctrl+H
For the Find What - type: ??????D or *D
For the Replace With - leave it blank
Then click on Replace All