Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Insert manual line break in formula
0 views
Skip to first unread message
0-0 Wai Wai ^-^
Sep 8, 2005, 6:08:19 AM9/8/05
to
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
Roger Govier
Sep 8, 2005, 7:03:03 AM9/8/05
to 0-0 Wai Wai ^-^
Hi
Format the cell Format>Cell>Alignment>Wrap text
Insert Char(10) within your formula where you want a new line.
e.g.
="I am a "&A30& char(10)&" You are a "&A31& char(10)&" We are "&A34
Format the cell Format>Cell>Alignment>Wrap text
Insert Char(10) within your formula where you want a new line.
e.g.
="I am a "&A30& char(10)&" You are a "&A31& char(10)&" We are "&A34
0 new messages