View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.misc
David McRitchie David McRitchie is offline
external usenet poster
 
Posts: 903
Default Merging of cell content i a Worksheet

Hi Morten,
For the future, if you have a lot of these
to do in entire columns and don't want to mess with cleaning
off worksheet formulas when done you might want to use a
macro if it fits your needs (puts a space in between for each
cell's te4xt it annexed).
http://www.mvps.org/dmcritchie/excel/join.htm#join

I realize the thread is two weeks old, and you got
answers you could use with worksheet formulas.
--
HTH,
David McRitchie, Microsoft MVP -- Excel
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm


"Morten" wrote in message ...
Hi!
I wonder if there is an easy way to merge the contents of 3 cells into one
cell?
--
MarMor