Insert maunal line break in formula

  • Thread starter 0-0 Wai Wai ^-^
  • Start date
0

0-0 Wai Wai ^-^

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?
 
0

0-0 Wai Wai ^-^

Note:
I have moved my question to "microsoft.public.excel.worksheet.functions"
 
D

David McRitchie

and it would have been better to wait. One hour is not a long
time to wait. Anyway Char(10) as in the reply that you got in
the other newsgroup by Roger Govier. .
http://google.com/[email protected]

Basically you have the same people reading and responding in
several Excel newsgroups. Other factors are involved such as
time of day which newsgroup people read first.

But is was good of you to warn us that you posted elsewhere.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Insert manual line break in formula 3
Nested if statements Arrays - help!! 4
Formula not quite right...any help... 3
Insert page break 3
Excel Create a New line in a Word Link without double "" around result 0
how to insert line break in a formula 1
How do I set up a formula to repeat 5 consecutive cells in a colum 1
find last entry and insert page break & line 3

Top