Hi,

In column D is it possible to generate/write I then P then I then P if there is data in column N.

example of required:

column D | Column N
I | 123456A
P | 123456T
I | 1234E6
P | 12L456
I | kjdla23
P | 334llkdi

I hope this makes sense.

Thanks for any help,

David