Home |
Search |
Today's Posts |
#1
|
|||
|
|||
split cells with Alt+Enter
I have several cells where we have used Alt+Enter to force a new line within
the cell. Now we want to split those out into separate cells, inserting rows as needed to do to so it doesn't overright info in the cell below. Can this be done? |
#2
|
|||
|
|||
One method to split into separate cells.
Insert appropriate number of rows or insert cells below the data. Select the cell with the alt + enters. In the formula bar select the data then "Cut" Select enough cells below that cell and Paste(ignore the "not same size" message) and click OK The data is now in separate cells and CR's are gone. Gord Dibben Excel MVP On Fri, 15 Apr 2005 13:10:05 -0700, "PC" wrote: I have several cells where we have used Alt+Enter to force a new line within the cell. Now we want to split those out into separate cells, inserting rows as needed to do to so it doesn't overright info in the cell below. Can this be done? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I format cells and enter data to be valued for TIME and th. | Excel Worksheet Functions | |||
how can I move cells after data input without using enter or tab | Excel Discussion (Misc queries) | |||
Excel - cursor moves to other cells after I enter data, without h. | Excel Discussion (Misc queries) | |||
Heps to design Locked/Unlocked cells in protected worksheet | Excel Discussion (Misc queries) | |||
split combined Time Date cells | Excel Discussion (Misc queries) |