how to combine cells by selecting range?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
SPIRIT said:
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?
Click to expand...

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
 
Back
Top