Spliting a cell with multiple content into seperate rows

  • Thread starter Thread starter melmil
  • Start date Start date
M

melmil

I have a spreadsheet, with multiple entries in one cell. I want to split the
entries, so that they each are seperate rows. I am familar with the text to
column feature, but this would be text to row. Example:

One cell has: 1960
1961
1962
1963

I would like these each of these in a seperate row.

Is this possible?
 
It's an Excel question, not FrontPage.
Why do so many people ask Excel questions in this (wrong) newsgroup?
--
Tom [Pepper] Willett
Microsoft MVP - FrontPage
---------------------------
:I have a spreadsheet, with multiple entries in one cell. I want to split
the
: entries, so that they each are seperate rows. I am familar with the text
to
: column feature, but this would be text to row. Example:
:
: One cell has: 1960
: 1961
: 1962
: 1963
:
: I would like these each of these in a seperate row.
:
: Is this possible?
:
:
:
:
 
Back
Top