Spliting a cell with multiple content into seperate rows

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

Tom [Pepper] Willett

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

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

Similar Threads

Spliting a cell with multiple entries into seperate rows 1
VBA-Table Word 2019 - Move a selected text, from a cell to the adjacent cell to its right, by pressing the ENTER key 0
Embed the same Excel multiple times 0
Merging from an Excel file with graphics 1
Need Help with a VBA subroutine 0
Word VBA - Automatic change content of a cell in table using dropdown list 5
Adding a big matrix in Word 2013 5
Problem with SET & REF function 0

Top