 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / October 2006Newline (char(13)) in a formula
Hi I'd like to have a formula in a cel display its resultstring in multiple lines: e.g. if I have the following formula: ="First line of text" & Char(13) & "Second line of text" I would like to display it in two line in a single cell. If i do it like above i get a small square in stead of a newline break. How can I achieve this? Thanks a lot! Just to be complete, ive also troed char(10) and that also does not work > Hi > [quoted text clipped - 9 lines] > > Thanks a lot! Use Char(10) and also format it as wrap text Bob Umlas > Hi > [quoted text clipped - 9 lines] > > Thanks a lot! That did it, i forgot to format as wrap text, thats why it did not work in first time. Thanks Bob! > Use Char(10) and also format it as wrap text > Bob Umlas [quoted text clipped - 12 lines] >> >> Thanks a lot! > I'd like to have a formula in a cel display its resultstring in multiple > lines: > e.g. if I have the following formula: ="First line of text" & Char(13) & > "Second line of text" Rather than a formula, can you simply enter the following text: First line of text<alt-Enter>Second line of text <alt-Enter> means that you press and hold the Alt key while press the Enter key. Note: As always, you might need to expand the width of the cell in order to see the two lines exactly as you intend them. Suprisingly, Autofit does not do the job (at least not in Office Excel 2003). You can also use alt-Enter within a string in a formula; it is the same as concatenating char(10). For example: =if(true, "Line one<alt-Enter>Line two") But you will see a square box, not a new line, unless you format the cell to Wrap Text (Format > Cells > Alignment). > I'd like to have a formula in a cel display its resultstring in multiple > lines: > e.g. if I have the following formula: ="First line of text" & Char(13) & > "Second line of text" Rather than a formula, can you simply enter the following text: First line of text<alt-Enter>Second line of text <alt-Enter> means that you press and hold the Alt key while press the Enter key. Note: As always, you might need to expand the width of the cell in order to see the two lines exactly as you intend them. Suprisingly, Autofit does not do the job (at least not in Office Excel 2003). You can also use alt-Enter within a string in a formula; it is the same as concatenating char(10). For example: =if(true, "Line one<alt-Enter>Line two") But you will see a square box, not a new line, unless you format the cell to Wrap Text (Format > Cells > Alignment). |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.