Concatenate Problem

[John Calder]

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

 

[Gord Dibben]

John

=A1&B1&"-"&C1


Gord Dibben MS Excel MVP

 

[John Calder]

Thanks Gord, as usual you are spot on !!!!

Weel Done !!!

 

[Gord Dibben]

Appreciate the feedback John

Thanks Gord

Thanks Gord, as usual you are spot on !!!!

Weel Done !!!

Gord Dibben MS Excel MVP