I know that when you are typing in a cell, if you press ALT + ENTER, it will create a line break for you in the cell, and the resulting text will appear on separate lines. What I'm wondering now is if its possible to do this using a formula.
For example, what I'm trying to do is concatenate multiple bits of data and put them together into a single cell that has multiple lines.
e.g.
Date: Jan 1, 2010
Job: Cleaning
Time: 4 hours
Cost: 100
I want to be able to combine this using something like:
="The job of "&A2&" was performed on "&A1&". It took "&A3&" to do and the cost was $"&A4"&"."
Now this formula would result in:
The job of Cleaning was performed on Jan 1, 2010. It took 4 hours to do and the cost was $100.
What I want to do instead is be able to have the result appear like this:
The job of Cleaning was performed on Jan 1, 2010.
It took 4 hours to do and the cost was $100.
All within the single cell. I have lots of data that I would like to "drag down" so that it would automatically fill all of the cells accordingly rather than have all the data on a single line.
In this example, the single vs. double line isn't really important, but in my application, I want to split the data into 5 different lines, and it would be quite tedious to go through after the fact and split up the lines.
So is it possible to have a line break like this? Thanks for any help!
Bookmarks