Concatenate

[Pam]

In cell A3 I have a last name
In cell B3 I have a first name
In cell C3 I have a formula
=CONCATENATE(A3&" , ",B3)

In cell D3 I have the title of the employee.
How can the formula be altered so the text in C3
is - for example:
Smith, John - Technician

Thank you

 

[Murray]

Maybe something like this:
=CONCATENATE(A3,",",B3,"-",C3)

 

[Pam]

Thank you for your help Murray

-----Original Message-----
Maybe something like this:
=CONCATENATE(A3,",",B3,"-",C3)


.

 

[Adrian]

try this:

=A3&", "&B3" - "&D3


HTH.