Hi
you can use a formula like
=A1 & "-" & B1 & "-" & C1
and copy this down for all rows

--
Regards
Frank Kabel
Frankfurt, Germany


Rich wrote:
all, thanks for any response.

I would like to make a macro to take the contents of 3 columns of 20
numbers and letters, and combine them into one column to form a label
number.....this is relevant for a label making program that allows an
Excel import.

for example

A1 Port1 KVM

would turn into
A1-Port1-KVM

any help is appreciated.