Line break function?

  • Thread starter Thread starter Matt
  • Start date Start date
M

Matt

I have the following function

="A"&"B"&"C"

which gives: ABC

Is there a way to insert line breaks so that instead of displaying
ABC, it will display:
A
B
C
 
="A" & CHAR(10) & "B" & Char(10) & "C"

Format to Wrap Text and Row>Autofit.


Gord Dibben MS Excel MVP
 
You must log in or register to reply here.

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

Put parts of cell into separate columns 3
Excel TWO Instances of Excel One watching Other 3
Automatically change the text format the cell when use a specific text 10
Display data using hlookup, index-match and offset 1
Exported data to Excel 2007 has spaces between rows 1
Highlight rows of data based on value 1
Appending Pairs of Column Data! 1
Excel Concatenate with line breaks but ignore blank cells 3

Back
Top