Return while useing CONCATENATE

P

Pierre

I have list of cell that I am combining. I need some help in placing a
RETURN so that the combined cells are on more then one like.

example.
From: Project Manager John Doe Section 23
=CONCATENATE(B3," ",B4," ",B5)

To:
Project Manager
John Doe
Section 23
 
D

Dave Peterson

Or this:
=CONCATENATE(B3,CHAR(10),B4,CHAR(10),B5)
or
=B3&CHAR(10)&B4&CHAR(10)&B5
 

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