excel formula

  • Thread starter Thread starter Brian
  • Start date Start date
B

Brian

I'm trying to combine the data in one column w/the data in
another column. I know that the formula for row by row is
example:=B1&" "&C1 but I cant figure out how to do the
whole two columns at once! Please help if you can!Thanks
 
Brian,

Like Chuck's solution, but quicker and easier. Assuming that the column you
are targeting as D1, put the first formula in D1 as before, and as Chuck
says, move the mouse to the bottom right corner of the cell until the
cursor changes to the black cross. AT this point, double-click the mouse,
and the whole column autofills.
 
Back
Top