0-0 Wai Wai ^-^

Posts: n/a

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Automatically insert row and copy formula	Wendy	Excel Worksheet Functions	5	August 25th 05 06:35 PM
Formula checking multiple worksheets	sonic-the-mouse	Excel Worksheet Functions	2	June 5th 05 07:48 PM
if formula = negative #, then insert a word	Nicole L.	Excel Worksheet Functions	10	February 4th 05 10:34 PM
Challenging Charting	C TO	Charts and Charting in Excel	0	January 17th 05 06:57 PM
How to insert a complex formula in a cell with VBA	mircea	Excel Worksheet Functions	6	January 4th 05 08:12 PM

All times are GMT +1. The time now is 11:08 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us