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

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.
Format>Cells>Alignement 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
>
>
>

"Ron Coderre" <[email protected]> ¦b¶l¥ó
news:[email protected] ¤¤¼¶¼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.
> Format>Cells>Alignement 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. :-)
..
..
..

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" <[email protected]> ¦b¶l¥ó
> news:[email protected] ¤¤¼¶¼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.
> > Format>Cells>Alignement 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. :-)
> ..
> ..
> ..
>
>
>