Combinding cells?

R

Richard Miller

If I have info in cell A1 - A30 and infor in B1 - B30 and all the info in
the B cells I want over to the info in the A cells.
Kind of like just taking the line out between the A and B cells. Can you do
this?

Richard
 
P

Peo Sjoblom

=A1&" "&B1

copy down, I inserted a space, if you don't want that just use

=A1&B1

--

Regards,

Peo Sjoblom

Northwest Excel Solutions

www.nwexcelsolutions.com

(remove ^^ from email address)

Portland, Oregon
 
Top