split cells with Alt+Enter

G

Guest

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?
 
G

Gord Dibben

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top