| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can i add a line break into a formula in excel 2000?
For example: =concatenate(a1,a2,a3,a4) = ILIKEBEEFBURGERS, But I want it to
put the result into a single excel cell like this: I LIKE BEEF BURGERS But i cant see how to manually insert a line break into my statement as in something like: =concatenate(a1,<line break,a2,<line break,a3,<line break,a4,<line break,) Any suggestions would be appreciated, thanks :P |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Break cell into multiple lines by line break | Excel Discussion (Misc queries) | |||
| How do I get a line break when using a formula to combine cells | Excel Worksheet Functions | |||
| Insert manual line break in formula | Excel Worksheet Functions | |||
| Insert manual line break in formula | Excel Worksheet Functions | |||
| How do I Break links Using Excel 2000 | Excel Discussion (Misc queries) | |||
Threaded Mode
