Posted to microsoft.public.excel.worksheet.functions

TESA0_4

Posts: n/a

How do I get a line break when using a formula to combine cells

I want to combine names and addresses into single cells, but I want a line
break so that the name is on one line and the address on the next line within
a cell. When manually entering data to a cell ALT,ENTER gives line break. I
want the formula to give the same effect as ALT,ENTER.
I'm using Excel2003.
Thanks if you can help!!

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
Insert manual line break in formula	0-0 Wai Wai ^-^	Excel Worksheet Functions	3	December 11th 05 07:10 PM
Insert manual line break in formula	0-0 Wai Wai ^-^	Excel Worksheet Functions	1	September 8th 05 12:03 PM
Formula works in some cells, doesn't in other	Wowbagger	New Users to Excel	13	June 30th 05 03:21 PM
Formula checking multiple worksheets	sonic-the-mouse	Excel Worksheet Functions	2	June 5th 05 07:48 PM
Formula checking multiple worksheets	sonic-the-mouse	Excel Worksheet Functions	2	June 5th 05 03:28 AM

All times are GMT +1. The time now is 07:40 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us