| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do you "select locked cells" w/o "select unlocked cells"? | Excel Discussion (Misc queries) | |||
| Counting empty cells within a range of cells | New Users to Excel | |||
| Counting empty cells within a range of cells | New Users to Excel | |||
| Help adding text values | Excel Worksheet Functions | |||
| Convert data type of cells to Text,Number,Date and Time | Excel Worksheet Functions | |||
Linear Mode
