Concatentate text and insert blank line

B

Bethany

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?
 
B

Bethany

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!
 
B

Bethany

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!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top