Word Numbered List to Excel?

[mazingerZ]

Hi All,

I wonder if anyone might be able to help with the following. I have a very large numbered list in MS Word, in the following style:

1. Animals
1.1 Mammals
1.1.1 Dogs
1.1.1.1 Beagles
1.1.1.2 Pugs
1.1.2 Cats
1.1.3 Elephants
1.2 Fish
1.2.1 Cod

...and so on.

I am trying to bring this data into Excel (2007) but in a way so that:

"Animals" goes into column A.

"Mammals" and "Fish" go into column B (in their own cells, in different rows).

"Dogs" and "Cats" go into column C.

"Beagles" and "Pugs" go into column D...

and so on.

The idea is to have each line in a different row, but have the columns serve more or less the same function that the tab indents do when looking at it in Word. (I'm trying to create a "breadcrumbs" style list for each line item). I've tried using tabs as a delimiter for importing text into word, but it doesn't seem to recognize Word's tabs when applied through a numbered list.

I am not having much luck finding a solution. Can anyone help?

-koji K.

[NBVC]

Copy and paste the list as is in column A... make sure Column A is selected...

Then go to Data|Text to Column and select Delimited.. click next

choose Space and choose Other and type a period in the empty box.

Click Finish.

This should separate the list out into columns of numbers and text...



To get rid of the numbers...

First Select all the columns with data... and then go to the Home menu and click the down arrow at the Find & Select section and choose Go To Special. Select Constants and then uncheck the text, logical and errors checkboxes, leaving only Numbers checked. Click Ok.

Now hit Delete on the keyboard...

all numbers should be gone.

Delete column A to move everything left.

[mazingerZ]

Absolutely beautiful! Worked perfectly!! Thank you!!

[NBVC]

You are welcome,

Please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save

[mazingerZ]

Done (sorry for the delay!)