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