Hi bebo021999,
No, I don't any helping column because thee is a another data in my original file. Doesn't matter of automatic letter 'D', forget it. I will enter it manually. Is it possible to restrict other letters to be enter in column 'N' except 'D'?

I'm getting error 'the range specified could not be found' after entering a formula suggested by jhren.

Thank you.