how to combine cells by selecting range?

[SPIRIT]

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?

 

[DaveB]

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?

 

[JE McGimpsey]

You may find these macros helpful...

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

 

[JethroUK©]

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