The return symbol in Excel represents the line break function and controls how text flows inside a cell. Understanding this symbol helps users manage long content, wrap text, and prepare data for export or import operations.
Excel uses two related concepts, the line break character and the wrap text setting, to control cell display. This guide explains how the return symbol works and how you can use it intentionally in your spreadsheets.
| Symbol Name | Keyboard Shortcut | Formula Function | Display Effect |
|---|---|---|---|
| Line Break (Soft Return) | Alt+Enter (Windows) Option+Command+Enter (Mac) | CHAR(10) with wrap text on | Starts a new line within the same cell |
| Paragraph Mark (Hard Return) | Enter key | Not a formula character | Moves active cell down |
| CHAR Function Code | N/A | =CHAR(10) | Generates a line break when combined with concatenation |
Inserting line breaks with Alt Enter
Using Alt+Enter is the most common way to add a return symbol inside a cell. This method is often called a soft return because it does not move to the next cell.
On Windows, hold the Alt key and press Enter. On Mac, hold the Option and Command keys and then press Enter. The cursor moves to a new line in the same cell, and Excel stores a line break character there.
Soft returns respect cell width and wrap text settings. If wrap text is off, you may still need to adjust row height to see all lines.
Parsing data with formulas FIND SEARCH MID
When the return symbol is inserted using CHAR(10), you can locate and split text using text functions. This is helpful when you export data from other programs and need to separate address lines or list items.
The FIND function returns the position of the line break character. The MID function extracts text before or after that position. Combining these functions lets you parse structured content reliably.
For example, use FIND(CHAR(10), A1) to locate the break, then use LEFT and RIGHT to pull each segment into separate columns for cleaner analysis.
Cleaning and replacing line breaks
Extra or inconsistent line breaks can cause problems when you concatenate text or export to other systems. The SUBSTITUTE function can replace CHAR(10) with a space or another delimiter.
You may also use the CLEAN function to remove non-printable characters, though it does not always remove line breaks created with CHAR(10). Combining SUBSTITUTE and CLEAN often gives the best results for data hygiene.
Before you replace content, copy the original column so you can revert if needed. Test your formula on a small range to confirm behavior across different cell types.
Import export and CSV behavior
When you export Excel data to CSV, line break characters affect how text files are structured. Some applications treat a line break inside a cell as a record separator, which can shift rows or columns.
To avoid issues, consider replacing soft returns with spaces or another marker before exporting. Use formulas like =SUBSTITUTE(A1,CHAR(10)," ") to create a single-line version for external systems.
Check the target application documentation to see how it handles embedded line breaks in imported files.
Key points for mastering the return symbol in Excel
- Use Alt+Enter to insert a soft line break within a cell without leaving the cell.
- Wrap text setting and row height affect whether all line breaks are visible.
- Locate line breaks with FIND or SEARCH using CHAR(10) as the target text.
- Split content by extracting text before and after the position returned by FIND.
- Replace CHAR(10) with SUBSTITUTE before exporting to CSV to avoid parsing issues.
- Test changes on a copy of your data to prevent accidental data loss.
FAQ
Reader questions
How can I add a line break inside a cell on my laptop?
Press and hold the Alt key, then press Enter. This inserts a line break character and moves the insertion point to a new line within the same cell.
What does the FIND function return when I search for a line break in Excel?
FIND returns the position number of the line break character within the text string, which you can use with MID, LEFT, or RIGHT to split the content.
Will my line breaks disappear when I save the file as CSV? Line breaks inside cells can be interpreted as record delimiters in some CSV applications. It is safer to replace CHAR(10) with spaces or remove them before exporting if you encounter misaligned rows. How do I remove line breaks from multiple cells quickly?
Use SUBSTITUTE to replace CHAR(10) with a space, and combine it with CLEAN if needed. Apply the formula to the range, copy the results, and paste as values to overwrite the original data.