Concatenate Problem
John
=A1&B1&"-"&C1
Gord Dibben MS Excel MVP
On Mon, 13 Nov 2006 12:47:01 -0800, John Calder
wrote:
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
|