| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
combining cells' data into one cell
In my spreadsheet I have several instances of a title
followed by related cells (maybe 1 , 2 or more) of data. I want to take the cells of data and put them into the cell immediately to the right of this title. e.g. Cell "A10" contains "Title". Cell "A11" contains "text 1" Cell "A12" contains "text 2" Cell "A13" contains "text 3" I want cell "B10" to contain "text 1 text 2 text 3". Cell "A10" remains unchanged. Cells A11, A12 and A13 are to be deleted. How do i do this? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Combining data from 2 cells into 1 cell | Excel Discussion (Misc queries) | |||
| Combining data from multiple cells into one cell with commas | Excel Discussion (Misc queries) | |||
| Combining data from different cells and more... | Excel Worksheet Functions | |||
| Combining data from multiple cells into one cell. | Excel Worksheet Functions | |||
| Combining data (numeric format) in multiple cells into one cell (t | Excel Discussion (Misc queries) | |||
Threaded Mode
