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
|