Insert a Newline in Excel Formula (MacOS)

excel newline macos formulas
Xofo picture Xofo · Nov 4, 2009 · Viewed 18k times · Source

I am using MS Excel on a Mac.

I have a formula, and I wish to insert a newline into it:

Guests!A1 & " " & Guests!B1 & [newline here] Guests!C1

How can I do this?

Answer

richardtallent picture richardtallent · Nov 4, 2009

CHAR() is the appropriate function for an Excel formula, and you need character 10 (Line Feed) to create a line break. Example:

Guests!A1 & " " & Guests!B1 & CHAR(10) & Guests!C1

You'll need to have word-wrapping enabled on the cell, otherwise CHAR(10) will just look like a little square.

vbCRLF would be the right choice when using VBA (i.e., a macro). The question is about formulas, not VBA.

Related questions

Generating CSV file for Excel, how to have a newline inside a value

I need to generate a file for Excel, some of the values in this file contain multiple lines. there's also non-English text in there, so the file has to be Unicode. The file I'm generating now looks like this: (in …

Read More
Importing CSV with line breaks in Excel 2007

I'm working on a feature to export search results to a CSV file to be opened in Excel. One of the fields is a free-text field, which may contain line breaks, commas, quotations, etc. In order to counteract this, I …

Read More
vba userforms carriage return behavior

In a textbox of a userform in VBA, I would like to enable the feature where the user can add a new line in the textbox by pressing the "Enter" key on the keyboard. However, I had trouble finding a …

Read More