Try using this =text(sheet2!a1,"general")&"+"&text(sheet2!a2,"gen eral")
--
Hope this helps
Martin Fishlock, Bangkok, Thailand
Please do not forget to rate this reply.


"Krista F" wrote:

I am trying to merge two cells together from a different worksheet with the
values separated by the plus/minus symbol into one cell. I would also like
to retain the auto-update portion of if those values change in that sheet
they will in this new worksheet as well...

For clarity, I am trying to merge a mean and sd from two separate columns...
Using Excel 07 - Any suggestions would be super!