You could use a userdefined function that does the concatenation for you. Take
a look at J.E. McGimpsey's site:
http://www.mcgimpsey.com/excel/udfs/multicat.html

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

PBrunner wrote:

I can merge multiple cells int o one cell using the & " "& formula in Excel.
It works great. The problem arises when I need to use it again. There must be
away to merge contents without having to type that formula over and over. I
try to make a template but it does not work, so I have to type the formula &"
" for approximately 40 to 50 cells.
Does anyone know how I can have one formula to wear I can copy my
information and paste it into the merge cells formula and have it work
correctly? I am trying to make a template that can bve used repeatedly with
out having to type that long formula for each cell.
Thankyou, Pierre Abadie

--

Dave Peterson