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?

The CONCATENATE(...) function will do that. For example if A1 had value
"Microsoft" and B1 had value "Excel" the formula:

=CONCATENATE(A1," ",B1)

will return "Microsoft Excel"

Does that help?
--
Regards,

DaveB


"SPIRIT" wrote:

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?

You may find these macros helpful...

http://www.mcgimpsey.com/excel/subs/mergedata.html


In article ,
SPIRIT wrote:

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?

"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