=A1&":"&B1&":"&C1

Copy down as needed.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"israel" wrote in message
...
Hi,

I have 3 columns with 500 rows. I would like to combine 3 cells
horrizontally into 1 cell adding a colon (:) between each combined cell.

At the same time is it possible to indicate the first colon to be bold and
the rest normal?

I appreciate your response.
Thank you
--
smile