I have several worksheets that i want to combine into one with the data. I am using CONCATENATE to combine them, but they are all merging together as one paragraph instead of line by line from the other sheets.
I have several worksheets with the same information. I want to combine them on one worksheet. On each sheet, the column may say in worksheet1 (clean towels), the worksheet, same column will say (dirty tiles), and the third worksheet may say (soap scum in sink). I want to join those columns together into one worksheet so that all 3 of those items will be in the same column, but they are joining together as a paragraph, i want for instance the first one that says (clean towels) to be on a line by itself, then under it will be the next one (dirty tiles), etc., instead i am using CONCATENATE and they are running into each other with a space inbetween (ex. clean towels dirty tiles soap scum).
That is wrong (dirty towels-worksheet1-cell A1) (dirtyt tiles-worksheet2-cell A1) (soap scum in sink-worksheet3-cell A1). They are the same cells in different worksheets that i want jointed together in another worksheet showing all of them together. But mine are joined as a paragraph instead of one under the other. Here is the formula (=CONCATENATE('1N'!F4,'2S'!F4,'4th fl'!F4)
OK, I still not absolutely sure what you mean by 'showing them together' but try this.
1. Formula in cell F4 of my 'Concatenate' sheet below is:
2. Select cell F4 then Format|Cells...|Alignment|Wrap Text|OK
3. With the cell still selected: Format|Row|AutoFit
Looking back on it you might see that it was a little difficult to determine exactly what you wanted because in Excel when people refer to 'lines' they often really mean 'rows' or 'cells'. You didn't actually say that you wanted the results on different lines IN THE SAME CELL.
Anyway, glad you got what you wanted and trust that if you have any more difficulties, the Mr Excel board will help you resolve them.