Hi,
I apologize in advance that I am not proficient with computer jargon so Iwill try and explain what I need to do by figures.

I need to generate a list like this in one column:

xxxxx-xx10
xxxxx-xx10
xxxxx-xx11
xxxxx-xx11
xxxxx-xx12
xxxxx-xx12 and so on

In a separate column I need to change the numbers to this:

xxxxx-xx10-P
xxxxx-xx10-C
xxxxx-xx11-P
xxxxx-xx11-C
xxxxx-xx12-P
xxxxx-xx12-C and so on

Is this a quick way to do this please? I am currently typing each entry - not very time efficient!

I will greatly appreciate any suggestions.