One way, with say data in Columns A, B, and C, try this in say D1:

=A1&"-"&B1&"-"&C1

And copy down as needed.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"officegirl" wrote in message
...
Can one do the opposite of Text to column
have data in several different columns and merge them into one with a -
btw
the content of the diff. columns?