Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
I need to be able to put 4-5 sentences into one cell. The spreadsheet is
done but now I need to manipulate the date in the third column. I wish to put each 4-5 sentence segment into one cell to do this. How |
#2
![]() |
|||
|
|||
![]()
I'm not exactly sure what you mean. Do you need to combine the text from
several cells into 1 cell? Use the Concatenate function: =CONCATENATE(A1,A2,A3...). Hope this helps. "tysonfoggie" wrote: I need to be able to put 4-5 sentences into one cell. The spreadsheet is done but now I need to manipulate the date in the third column. I wish to put each 4-5 sentence segment into one cell to do this. How |
#3
![]() |
|||
|
|||
![]()
You can either:
Right mouse click on the cell you wish to add the 4-5 sentences to and select Format cells from the list. Click on the Alignment tab at the top of the dialog box and select Wrap Text at the bottom. or Type in the first line of text required, press ALT+Enter at the end of the first line which will create a new line within the cell for you to continue typing. I hope this helps. "tysonfoggie" wrote: I need to be able to put 4-5 sentences into one cell. The spreadsheet is done but now I need to manipulate the date in the third column. I wish to put each 4-5 sentence segment into one cell to do this. How |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
AutoFIll -by dragging the bottom-right corner of the cell | Excel Discussion (Misc queries) | |||
how to create a variable column in cell reference | Excel Worksheet Functions | |||
Can a Formula in Cell X modify Cell Y? | Excel Discussion (Misc queries) | |||
inserting data from a row to a cell, when the row number is specified by a formula in a cell | New Users to Excel | |||
VLookup resulting in a blank cell... | Excel Worksheet Functions |