What you should probably do is highlight all the cells from which you want to delete the carriage returns first, then go into VBA and find the window for the sheet you are working on (or any Module for that matter). Mac Excel 2011 - Text to Column - Carriage Return as delimiter Hi there, As the title suggests, I'm trying to use the Text to Column function with carriage return as the delimiter (trying to parse addresses).
Excel There's 3 ways to get a carriage return or paragraph return or line feed within a cell.
Method 1 - Cell Wrapping
Often, you need only set the cell to wrap text, and you can set the width of the cell to whatever is desired. Choose FormatCells, Alignment tab, and check Wrap text.
This is the result:
Method 2 - Insert a Return
![Search/replace carriage returns in excel Search/replace carriage returns in excel](/uploads/1/2/5/7/125716680/694279881.png)
![Mac Mac](/uploads/1/2/5/7/125716680/731912259.png)
This one's a no-brainer. Just type the first line, hit Alt+Enter and type the second line. The result is virtually the same as above, however, if you copy and paste this to Word, for instance, you'll end up with a line break. Or if you export to CSV or other text format, you may get unexpected results.
Method 3 - Using a Formula
To use this, you must have wrap text selected. Here's a sample formula:
=a1&char(10)&a2
The results, again, are the same as above. However, if you forget to wrap text on the cell, you'll see this: