How do I insert a line break using a formula (e.g when concatenat.

B

blustripes

I'm concatenating values from multiple cells into a single cell and want to
put a line break in between them so as instead of getting e.g.
Mary,Tom, Ted
they appear as follows within a single cell:
Mary
Tom
Ted

I know I can do this manually using CTRL+carriage return but how can I do it
within my formula?
 
D

David Biddulph

=A1&CHAR(10)&A2&CHAR(10)&A3
Remember to format the cell to allow word wrap.

Are you sure you mean "CTRL+carriage return" and not Alt-Enter?
 

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

Similar Threads

Interchange line break and paragraph break shortcut keys 9
Concatentate text and insert blank line 2
How do I get a line break when using a formula to combine cells 5
Line Break Vlookup 2
Insert Row also adds formulas and moves cursor 2
Breaking a line within a formula - HELPHELP PLEASE 2
How do I insert a line feed in a formula? 5
how to insert individual lines into a cell 3

Top