For example, if you enter a formula +c5+d5 in a cell, the cell itself will show you the result of the formula but the formula bar will show the actual formula. You used to be able to put a line break while you’re in the formula bar but with Excel for Mac, you have to be in the cell itself for the Option+Command+Enter to insert a line break.
![Break Break](/uploads/1/2/5/4/125446651/915438267.png)
For example, it might be more convenient for the reader to display an address in a cell like this: John MacDougall 123 Fake Street Any Town Canada Rather than like this: John MacDougall, 123 Fake Street, Any Town, Canada In this post I’ll show you how to separate the data in your cells based on the in-cell line breaks. This can be useful when doing any sort of data analysis on the data.
In this example, we have address data which includes a person’s name, address, city and country. The data is in one cell for each person but the name, address, city and country are on different lines. Text to Columns wizard step 2. Select Other from the Delimiters options and deselect all the rest of the options. In the input box to the right of Other press Ctrl + J to insert a line break as your delimiter. You should see dividers appear in the Data preview pane where there are line breaks in your data.
Press the Next button. Text to Columns wizard step 3. Use the range selector icon to choose a destination for the divided data. Select a cell outside of the original data range to keep a copy of the original data. Check the Data preview to make sure the text to column is correct. Press the Finish button.
Thank you very much You can see by the steady stream of “thank you” replies (more than 18 months now) that this is much needed and hard-to-find tip. Just for a moment, consider how much time it took to offer this advice and then the resultant positive impact on so many people (imagine the countless many that have benefited but did not write their thanks). This might seem to overstate this. But how many individuals were out there tearing their hair out as a deadline was bearing down on them only to have this stupid little frustration get in their way. Well done, and again, thank you. It is such a pain that Excel in Mac is so different from Windows. I find the Mac version very awkward.