Concatentate text and insert blank line
 

For each row, I have text in 3 columns that I want to concatenate into one
cell with a return after each line.

Example, given a row with the following...

A1 - "This is"
A2 - "my"
A3 = "sample date"

I'm trying to write a concatenate formula so that the contents of each
source cell (A1 thru A3) appears on a line by itself, but all within a single
cell so the output is:

This is
my
sample data

How do I concatenate text with a new line code?

Concatentate text and insert blank line
 

Try the below ...and check wordwrap for the formula cell..
FormatCellsAlignmentWordWrap

=A1&CHAR(10)&A2&CHAR(10)&A3

If this post helps click Yes
---------------
Jacob Skaria


"Bethany" wrote:

For each row, I have text in 3 columns that I want to concatenate into one
cell with a return after each line.

Example, given a row with the following...

A1 - "This is"
A2 - "my"
A3 = "sample date"

I'm trying to write a concatenate formula so that the contents of each
source cell (A1 thru A3) appears on a line by itself, but all within a single
cell so the output is:

This is
my
sample data

How do I concatenate text with a new line code?

Concatentate text and insert blank line
 

First, make sure word wrap is enable for the cell, and that the row is tall
enough to display all 3 lines. Then, the formula is:

=A1&CHAR(10)&A2&CHAR(10)&A3

CHAR(10) is a line feed
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Bethany" wrote:

For each row, I have text in 3 columns that I want to concatenate into one
cell with a return after each line.

Example, given a row with the following...

A1 - "This is"
A2 - "my"
A3 = "sample date"

I'm trying to write a concatenate formula so that the contents of each
source cell (A1 thru A3) appears on a line by itself, but all within a single
cell so the output is:

This is
my
sample data

How do I concatenate text with a new line code?

Concatentate text and insert blank line
 

You can do it like this:

=A1&CHAR(10)&A2&CHAR(10)&A3

You need to set the cell format to Wrap Text.

Hope this helps.

Pete

On Nov 10, 4:39*pm, Bethany wrote:
For each row, I have text in 3 columns that I want to concatenate into one
cell with a return after each line. *

Example, given a row with the following...

A1 - "This is"
A2 - "my"
A3 = "sample date"

I'm trying to write a concatenate formula so that the contents of each
source cell (A1 thru A3) appears on a line by itself, but all within a single
cell so the output is:

This is
my
sample data

How do I concatenate text with a new line code?

Concatentate text and insert blank line
 

Bingo! That's what I needed... I just didn't know the code for the line feed
(nor was I sure if the concatentate function would support it.)

Thanks!

"Jacob Skaria" wrote:

Try the below ...and check wordwrap for the formula cell..
FormatCellsAlignmentWordWrap

=A1&CHAR(10)&A2&CHAR(10)&A3

If this post helps click Yes
---------------
Jacob Skaria


"Bethany" wrote:

For each row, I have text in 3 columns that I want to concatenate into one
cell with a return after each line.

Example, given a row with the following...

A1 - "This is"
A2 - "my"
A3 = "sample date"

I'm trying to write a concatenate formula so that the contents of each
source cell (A1 thru A3) appears on a line by itself, but all within a single
cell so the output is:

This is
my
sample data

How do I concatenate text with a new line code?

Concatentate text and insert blank line
 

I got the word wrap, but didn't know the code for the line feed (nor was I
sure if the concatentate function would support it.) thanks for your help!

Thanks!

"Luke M" wrote:

First, make sure word wrap is enable for the cell, and that the row is tall
enough to display all 3 lines. Then, the formula is:

=A1&CHAR(10)&A2&CHAR(10)&A3

CHAR(10) is a line feed
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Bethany" wrote:

For each row, I have text in 3 columns that I want to concatenate into one
cell with a return after each line.

Example, given a row with the following...

A1 - "This is"
A2 - "my"
A3 = "sample date"

I'm trying to write a concatenate formula so that the contents of each
source cell (A1 thru A3) appears on a line by itself, but all within a single
cell so the output is:

This is
my
sample data

How do I concatenate text with a new line code?