How to concatenate with line breaks

In this video we’ll look at a clever way to make this task easier and less error-prone.

A common example of a situation that requires concatenation is assembling a mailing address from data in separate columns.

This works, but notice that everything just ends up on the same line.

To fix this, I need to insert actual line breaks, and this is where theCHAR functionis useful.

On Windows, character 10 is a line break and on the Mac, it’s character 13.

To add line breaks, I just need to use the CHAR function with the appropriate number.

Once I add the character formula where I need the line breaks, the address will display correctly.

Note that you must have text wrapping enabled when you use line breaks.

This works fine, but it’s a hassle to string together all these references with literal text.