"SPIRIT" wrote in message
...
hi, i can't merge the contents of multiple cells by selecting a range. i
cannot waste hours by entering the cell's address maunally. Is there
formulla
to do that?

if the ranges are the same size and you just want to add one range to the
other without using a seperate formula

select one range
edit/copy
select the other range
edit/paste special
operation = Add
OK