Insert a Line Break in a Cell

**mgraf** · 10-23-2018, 02:41 PM

I know how to insert a line break using Alt+Enter. I want to insert a line break using a formula. ie. =A1 & B1 with a line break between the two values.

**FlameRetired** · 10-23-2018, 02:47 PM

Hi mgraf. Welcome to the forum.

Try

=A1&CHAR(10)&B1

You may have to format to Wrap text.

**mgraf** · 10-23-2018, 03:04 PM

Thanks Dave!

**FlameRetired** · 10-23-2018, 04:43 PM

You're welcome. Glad to help, and thanks for marking your thread Solved.

Insert a Line Break in a Cell

LinkBack

Thread Tools

Rate This Thread

Display

Insert a Line Break in a Cell

Re: Insert a Line Break in a Cell

Re: Insert a Line Break in a Cell

Re: Insert a Line Break in a Cell

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] VBA code to insert line break within a cell if specific criteria is met.

Help with "Insert a line break in a cell"

[SOLVED] Insert a line break (CHAR(10)) after every 42 characters

[SOLVED] VBA to insert line break (Alt+Enter)

Insert manual line break in formula

Insert maunal line break in formula

line break in a cell-Is there a way to get the line break instead of a symbol?

Bookmarks

Bookmarks

Posting Permissions