linking two text colums in a third column

inktec · Jul 31st 2004

I have two columns with text and want to link them in a third coloumn.

i.e

Colomn A = 51645AE
Colomn B = HP Orginal Toner Cartrridge

Colomn C = 51645AE - HP Orginal Toner Cartrridge

Help on a formula would be most appreciatted.

Thanks,

Botswana

Anonymous · Jul 31st 2004

in column C (for row 1) enter:

=A1 & " - " & B1

Using the CONCATENATE function instead would be equivalent.

=CONCATENATE(A1," - ",B1)

inktec · Jul 31st 2004

many thanks for your help

Participate now!