How to insert carriage return in the middle of a text formula to .
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. -- Dave |
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) "Dave" wrote in message ... 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. -- Dave |
Hi Dave
=A1&CHAR(10)&B1 Make sure the cell is preformatted with "wrap text". HTH. Best wishes Harald "Dave" skrev i melding ... 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. -- Dave |
All times are GMT +1. The time now is 10:20 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com