=a1&" "&b1&" "&c1&" "&d1&" "&e1

Put it in the cell that should show the results of this "merge". (It's usually
called concatenation.)

If you have formated dates/numbers, you may want something like:

=text(a1,"mm/dd/yyyy")&" "&text(b1,"$0.00")&.......etc



Mary wrote:

I have read the previous posts about merging cells, but I am lost. Is there
a formula to merge 5 cells, with a space between each that I can apply to the
whole table? WHere do I put the forumla, etc. I apologize in advance, I am
not very familar with excel.

--

Dave Peterson