Cell Formatted w/ Word Wrap--Force Text to Next line?

  • Thread starter Thread starter RDI
  • Start date Start date
R

RDI

We have an Excel Worksheet that we want to control where the line feed
occurs in our cell. Is there something we can insert into the text string
to force the line feed?

I was thinking of something like =concatenate("This is the first Line",
CRLF, "This is the second Line"). Word Wrap IS turned on under the cell
format.
 
RDI

When typing into the cell, use Alt and Enter to force a carriage return
within the cell.

Andy.
 
Thanks--I THOUGHT it would be something simple. I tried ctrl+enter, but
that didn't do it and I never thought about alt+enter.

I know that in Word, if you press Ctrl+Tab, it will put a tab within the
cell.
 
Back
Top