Insert manual line break in formula
Hi
I have a formula which combines texts from several sources. Eg: ="I am a "&A30&". You are a "&A31&". However we don't "&A32&", nor "&A33&". Except that, we do "&A34&"." However the whole statement will appear in 1 line. I would like to break it into 3 lines in that cell. How to do? -- Additional information: - I'm using Office XP - I'm using Windows XP |
Insert manual line break in formula
Try something like this:
="I am a "&A30&". You are a "&A31&". "&CHAR(10)&"However we don't "&A32&", nor "&A33&". "&CHAR(10)&"Except that, we do "&A34&"." Note: You'll need to set your cells to wrap text and set column widths. FormatCellsAlignement Tab Check: Wrap Text Does that help? *********** Regards, Ron "0-0 Wai Wai ^-^" wrote: Hi I have a formula which combines texts from several sources. Eg: ="I am a "&A30&". You are a "&A31&". However we don't "&A32&", nor "&A33&". Except that, we do "&A34&"." However the whole statement will appear in 1 line. I would like to break it into 3 lines in that cell. How to do? -- Additional information: - I'm using Office XP - I'm using Windows XP |
Insert manual line break in formula
"Ron Coderre" ¦b¶l¥ó ¤¤¼¶¼g... Try something like this: ="I am a "&A30&". You are a "&A31&". "&CHAR(10)&"However we don't "&A32&", nor "&A33&". "&CHAR(10)&"Except that, we do "&A34&"." Note: You'll need to set your cells to wrap text and set column widths. FormatCellsAlignement Tab Check: Wrap Text Does that help? It helps a lot although this solution is not perfect. :D By the way, would you mind telling me what's the point of adding "CHAR(10)"? I would like to understand why. Thanks. :-) .. .. .. |
Insert manual line break in formula
Char(10) refers to the ASCII code 10, which represents a line break or "line
feed". Consequently, putting the &Char(10)& in a string is the equivalent of [Alt]+[Enter] in the string. For a list of other ASCII codes...try this link: http://www.neurophys.wisc.edu/www/comp/docs/ascii.html Does that help? *********** Regards, Ron "0-0 Wai Wai ^-^" wrote: "Ron Coderre" ¦b¶l¥ó ¤¤¼¶¼g... Try something like this: ="I am a "&A30&". You are a "&A31&". "&CHAR(10)&"However we don't "&A32&", nor "&A33&". "&CHAR(10)&"Except that, we do "&A34&"." Note: You'll need to set your cells to wrap text and set column widths. FormatCellsAlignement Tab Check: Wrap Text Does that help? It helps a lot although this solution is not perfect. :D By the way, would you mind telling me what's the point of adding "CHAR(10)"? I would like to understand why. Thanks. :-) .. .. .. |
All times are GMT +1. The time now is 03:15 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com