Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Putting text together from 3 cells
Hi i have 3 cells a1 a2 a3 all with about 2 sentences of data in, i
want to take all that data and put it in one cell, however i wish to seperate each piece of data from each cell with a carrige line space and title like below go from this : cell a1: helloe i am the data in a1 cell a2: hello i am the data in a2 cell a3: hello i am the data in a3 to this cell b1: a1 data hello i am the data in a1 a2 data hello i am the data in a2 a3 data hello i am the data in a3 hope this makes sense, been trying to solve this but cannot get the line spaces or add the titles to each cell value |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
taking numbers in vertical cells putting them in horizontal cells | Excel Worksheet Functions | |||
Putting text into graph | Charts and Charting in Excel | |||
Putting text in a column based on variable text from another colum | Excel Discussion (Misc queries) | |||
copying text from one group of cells and putting them in a table? | Excel Programming | |||
Putting text in a cell | Excel Programming |