ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Combinding cells? (https://www.excelbanter.com/excel-discussion-misc-queries/82035-combinding-cells.html)

Richard Miller

Combinding cells?
 
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



Peo Sjoblom

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




All times are GMT +1. The time now is 03:30 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com