| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Split several sentences in one cell
Hi
Will someone please tell me if there is a formular to split several sentences in one cell ? I have many lines in one cell, and I want each sentence to be below the other. I have have put an extra large space between the sentences. Can this be done with a formular? I tried - format - cell to try a different format, but it didn't work. Thanks :-) Therese |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Split several sentences in one cell
Hi,
Not sure if you want to split your cell accross multiple rows, but if you just want to have them one under each other in the same cell, then Alt + Enter will put a hard return in for you. HTH Simon Therese wrote: Hi Will someone please tell me if there is a formular to split several sentences in one cell ? I have many lines in one cell, and I want each sentence to be below the other. I have have put an extra large space between the sentences. Can this be done with a formular? I tried - format - cell to try a different format, but it didn't work. Thanks :-) Therese -- -------------------- Simon - UK Email at simon22mports [ a t ] hot mail [ d ot ]com Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...excel/200704/1 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Split several sentences in one cell
Therese
Select the cell then EditFillJustify. Click "OK" to the message. OR select the cell and enough cells below it then EditFillJustify Gord Dibben MS Excel MVP On Tue, 3 Apr 2007 06:42:01 -0700, Therese wrote: Hi Will someone please tell me if there is a formular to split several sentences in one cell ? I have many lines in one cell, and I want each sentence to be below the other. I have have put an extra large space between the sentences. Can this be done with a formular? I tried - format - cell to try a different format, but it didn't work. Thanks :-) Therese |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| format cells to display 20 long sentences in a single cell | Excel Discussion (Misc queries) | |||
| Adding periods to sentences. | Excel Discussion (Misc queries) | |||
| format a cell to accept sentences... using return key | Excel Discussion (Misc queries) | |||
| Split sentences into words | Excel Discussion (Misc queries) | |||
| I need to put 4-5 sentences into one cell. | Excel Worksheet Functions | |||
Hybrid Mode
