New line in excel cell mac not working

Dealing with text in Excel can be painful as the formatting is limited within Excel cells. One method of organizing text is to add line breaks. In this article, we’ll explore ways of dealing with new lines in Excel.

Insert line breaks manually with Alt + Enter

Inserting a line break in Excel is quite easy: Just press Alt + Enterto add a line break inside a cell.

New line in excel concatenate formula

This keyboard shortcut works the same way on Windows and the Office 2016 for Mac.

Insert line breaks with a formula

Let’s say you want to add a line break within the CONCATENATE formula or the ‘&’ when you combine two text cells.

This works with the code CHAR(10).

Example: A1 has a text and B1 as well. You want to combine them but add two breaks between them. The formula would be:

Please note: In order to see the line breaks, entered via Excel formulas, you have to activate “Wrap Text”: Just click on the “Wrap Text” button on the Home ribbon.

How to search for new lines in Excel

You can use the search function in Excel to search for new lines.

Follow

remove line break in excel formula

find line break in excel formula