Concatenate Problem
 

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

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

Concatenate Problem
 

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

Weel Done !!!

"Gord Dibben" wrote:

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

Concatenate Problem
 

Appreciate the feedback John

Thanks Gord

On Mon, 13 Nov 2006 13:50:01 -0800, John Calder
wrote:

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

Weel Done !!!

"Gord Dibben" wrote:

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




Gord Dibben MS Excel MVP