View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
0-0 Wai Wai ^-^
 
Posts: n/a
Default 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