Hi All,

I need help in creating a macro which can validate IDs listed in a
column in spread sheet.

There is a fixed format for each ID:

The first 5 places of the ID should be characters.
The next 4 should be numericals
Last 1 should be a character
4th character from beginning should be "P"

Examples of some of the IDs:

ACCPR4243A
BDKPZ6145M
LNHPC3807D

thank you all in advance.

Sri...