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?

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?

hi
somethink like this formula should work for you...
in D5, enter....
=CONCATENATE(A5&"-"&B5&"-"&C5)

adjust to fit your data.

Regards
FSt1
"officegirl" wrote:

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?

Not as easy but it is possible

=A1&" "&B1&" "&C1 and so on

will put whatever is in those cells separated by a space in one cell
you can then copy and paste special as valued in place to make it a fixed
value


--


Regards,


Peo Sjoblom


"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?