Hi

I have entries in 3 different columns.

A1 = PN
B1 = 62456
C1 = D

I would like to concatenate the 3 entries but to also have a dash (-)
between the 62456 and the D.

End result should read PN62456-D

Is this possible?

Any help would be much appreciated

John