How to insert carriage return in the middle of a text formula to .

G

Guest

I want to insert carriage return in the middle of a text formula to force the
resulting text to wrap at a specific point. It would be the same thing as
pressing Alt/Return while entering text manually except that the text is
being created in a formula.
 
B

Bob Phillips

You can do it with Alt-Return, but the formulas have a nasty tendency to not
work then.

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
H

Harald Staff

Hi Dave

=A1&CHAR(10)&B1
Make sure the cell is preformatted with "wrap text".

HTH. Best wishes Harald
 

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

carriage return in text cell in excell 2
Select text before carriage return 2
Unicode text and carriage returns 4
Cut and Paste Text with CRLF into Single Cell 1
Carriage return symbol - how to split columns at 6
Excel - carriage returns and formating of text within a cell 2
Separating carriage return data into separate cells 2
Configure Formula Bar 6

Top