Text to Column

  • Thread starter Thread starter officegirl
  • Start date Start date
O

officegirl

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.
 
hi
somethink like this formula should work for you...
in D5, enter....
=CONCATENATE(A5&"-"&B5&"-"&C5)

adjust to fit your data.

Regards
FSt1
 
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
 
Back
Top