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

G

Guest

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

How do I get a line break when using a formula to combine cells 5
How do I insert a line feed in a formula? 5
Concatentate text and insert blank line 2
Insert manual line break in formula 3
Excel: How to insert carriage returns in a formula to manipulate t 1
multiple search results 3
Line Break Vlookup 2
Excel Create a New line in a Word Link without double "" around result 0

Top