View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Peo Sjoblom
 
Posts: n/a
Default Combinding cells?

=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




"Richard Miller" wrote in message
news:0qlZf.1858$up2.939@fed1read07...
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