How to Wrap Text in Google Sheets Using a Formula

To make text appear on separate lines inside a Google Sheets cell, insert a line break with CHAR(10) in a formula, then turn on wrapping with Format > Wrapping > Wrap. The formula creates the break; the formatting setting makes the cell display it as multiple lines. You can use this to combine values, split a list into lines, or make long entries easier to read.

This guide is for Google Sheets in a web browser. You will need access to the sheet and permission to edit the cells or formatting. If you only need to wrap existing text without changing it with a formula, you can turn on wrapping directly; the formula is useful when you want to add deliberate line breaks as part of the cell’s calculated result.

What You’ll Need

A Google account and a spreadsheet open in Google Sheets in a web browser.
Some text or cell values to combine or split, plus an empty destination cell for the result.
Permission to edit the spreadsheet. If you do not have permission, ask the owner for edit access or make an editable copy if that option is available.

Step-by-Step

Choose the text and destination cell. Decide which values should appear on separate lines and where the result should go. For example, you might put a person’s name in column A, their job title in column B, and the combined, two-line label in column C. Using a separate destination cell helps preserve the original values and makes it easier to check the result.
Enter a formula that joins two values with a line break. With a name in A2, a job title in B2, and the result going in C2, enter =A2&CHAR(10)&B2 in C2. For example, if A2 contains Maya Chen and B2 contains Support Lead, the formula returns Maya Chen on the first line and Support Lead on the second. Press Enter to calculate it. The ampersands join the first value, the line-break character, and the second value; CHAR(10) is the line break.
Turn on wrapping for the result cell. Select C2, then choose Format > Wrapping > Wrap. This tells Sheets to display text on multiple lines within the cell instead of letting it spill across neighboring cells or appear clipped. If you want to apply the setting to multiple results, select the whole destination range or column before choosing the menu command. The toolbar also has a text-wrapping control, where you can select Wrap.
Check the row height and column width. The row may expand to show wrapped lines, but a narrow column can make each line break in additional places. Widen the column if the result is difficult to scan. If the cell still looks cut off, select the affected row, right-click its row number, and choose Resize row; then choose an appropriate height or fit the row to its data. A manually fixed row height can keep part of the wrapped text hidden.
Use a line break between several cells, if needed. With values in A2:A4 and the combined result going in B2, enter =TEXTJOIN(CHAR(10),TRUE,A2:A4) in B2. If the cells contain North, Central, and South, the result is those three words, one per line. The TRUE argument tells the function to ignore empty cells, so an empty entry does not create an extra blank line. Turn on wrapping for B2 as well.
Split a delimited value onto separate lines. If A2 contains Red, Blue, Green and you want each color on its own line in B2, enter =SUBSTITUTE(A2,", ",CHAR(10)) in B2. This replaces each comma followed by a space with a line break, so the result reads Red, then Blue, then Green on separate lines. The characters in the text to replace must match what is actually in A2; for example, a comma without a following space needs a different search string.
Copy the formula to other rows when appropriate. If each row has a name in column A and a role in column B, select the formula cell and drag its small blue fill handle down the column. Sheets adjusts relative references as the formula is copied: the next row will refer to A3 and B3. Check one or two copied results to ensure the source cells line up as intended, and apply Wrap to the full output range if it is not already set.
Keep the formula result separate from its display setting. If you change the text formula but do not see multiple lines, first confirm that the formula contains CHAR(10), then confirm Wrap is enabled on the result cell. A formula changes the value returned by the cell; it does not set the cell’s formatting. This distinction is the most important part of getting formula-based wrapping to work.

For Excel users: the line-break idea also works with CHAR(10) in Excel, but the wrapping control is in a different place. In Excel for Microsoft 365 on Windows, use Home > Wrap Text. In Google Sheets, use Format > Wrapping > Wrap.

Common Mistakes

Expecting the formula to turn on wrapping. A formula can return a line-break character, but it cannot change the cell’s wrap setting. Apply Wrap separately to the result cell or range.
Using the wrong line-break character. For a line break in a Google Sheets formula, use CHAR(10). A space or punctuation mark will not create a new line, and typing the characters CHAR(10) inside quotation marks would return literal text rather than call the function.
Putting the formula in a source cell. If a formula refers to the same cell it occupies, it can create a circular dependency. Put the result in a different cell from the values it uses, such as placing the formula in C2 when the inputs are A2 and B2.
Using a delimiter that does not match. A replacement formula only finds the exact text you specify. A comma-space search will not match a semicolon, a comma with no space, or a line break that is already in the source.
Assuming each visual line is a formula line break. Sheets can also wrap a long line automatically because the column is narrow. That is different from a deliberate break inserted with CHAR(10); changing the column width can alter automatic wrapping but does not remove the formula’s line breaks.
Overwriting the formula with its result. Typing directly into the formula cell replaces the calculation. Edit the source cells instead if you want the displayed result to update automatically.

Tips

Choose the simplest formula for the job. Use the ampersand when combining a small number of known cells, TEXTJOIN when collecting a range, and SUBSTITUTE when replacing a repeated separator inside one text value.
Make the formula easy to maintain. Put source data in separate columns and keep the combined display in another column. That way, you can sort, filter, or edit the original values without having to separate a combined label later.
Use a range-wide format when filling formulas down. Select the destination column or the range you plan to use, then set Wrap once. This avoids a mix where some formula results wrap and others remain on one line.
Remember that blank inputs can affect the appearance. A simple join formula may still add a line break if one of its source cells is empty. For a range where blanks should be skipped, TEXTJOIN(CHAR(10),TRUE,range) is often a better fit.
Check the sheet’s locale if a formula is rejected. The examples use commas between function arguments, which is standard in many Sheets locales. Some locale settings use semicolons instead. If Sheets reports a formula parse error, check File > Settings and use the argument separator expected by that spreadsheet.
Do not confuse wrapping with text overflow. Wrap keeps text within the cell and displays extra lines. Clip hides text that does not fit, while Overflow can let text extend into empty cells. Use Wrap when the goal is to show the entire value inside the cell.

Troubleshooting

The output stays on one line. Select the formula cell and choose Format > Wrapping > Wrap. Also inspect the formula to make sure CHAR(10) is between the values. If you see the characters CHAR(10) printed in the result, check that they are not enclosed in quotation marks.

The text is still hidden or cut off. Increase the column width or let the row grow to fit the wrapped content. Check for a manually set row height, merged cells, or a filter view that makes the available space hard to judge. Also confirm that Wrap, rather than Clip, is selected for the cell.

The formula shows an error. Confirm that the cell references are valid and that parentheses are balanced. If Sheets displays a formula parse error, check whether your locale expects semicolons rather than commas between arguments. For the simple join formula, verify that each cell reference and ampersand is present.

There are unexpected blank lines. One of the source cells may be empty, or the source text may include an existing line break. For a range, use TEXTJOIN with TRUE as its second argument to ignore empty cells. For a two-cell join, you may need a conditional formula if either source is sometimes blank; first decide whether a missing value should leave a blank line or be omitted entirely.

Only part of a phrase moves to the next line. The separator in your SUBSTITUTE formula may not match the source exactly. Compare the source text carefully, including spaces and punctuation. If the content uses a different separator, change the text being searched for to match it, or clean up the source values first.

Frequently Asked Questions

Can a Google Sheets formula turn on text wrapping?
No. A formula can return a line break, but wrapping is cell formatting. Add the break with a formula and enable Wrap through Format > Wrapping > Wrap.

What does CHAR(10) do in Google Sheets?
It returns a line-feed character, which works as a line break in a cell result. To see the result as separate lines, the cell generally also needs Wrap enabled.

Will the line breaks update when the source cells change?
Yes. A formula recalculates when referenced values change, so the joined text updates. The line-break position remains wherever the formula places it, unless the formula or source content changes.

Can I put several values on separate lines while skipping blanks?
Yes. Use TEXTJOIN with CHAR(10) as the delimiter and TRUE to ignore empty cells. Apply Wrap to the cell containing the result so the lines are visible.

Can I wrap text without a formula?
Yes. Select the cell or range and choose Format > Wrapping > Wrap. Use a formula only when you want to insert deliberate line breaks into a calculated result or combine text from other cells.

Does this work in Excel too?
The CHAR(10) line-break approach is also used in Excel formulas, but the menu path differs. In Excel for Microsoft 365 on Windows, select the cells and choose Home > Wrap Text; in Google Sheets, choose Format > Wrapping > Wrap.

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.