Exporting a word list to Excell

[Wickiup]

I have a large simple list of words in Word 2007 that I wish to export to
Excel 2007.

The list is like the following with no punctuation:

Duck
dog
turkey
frog
dance

How do I prepare this list so I can do the export/import thing?

Thanks

-*-
Jim Curts

 

[JoAnn Paules]

Did you try a simple copy and paste?

 

[Wickiup]

Yes, and it all ended up in one cell.

I finally tried an old online trick of saving the file as an .mht file
and it exported perfectly to Excel.

I realize there must be a more civilized method to to accomplish
this and am interested in learning of it.

Thanks

-*-
Jim Curts

Did you try a simple copy and paste?

--

JoAnn Paules
MVP Microsoft [Publisher]
Tech Editor for "Microsoft Publisher 2007 For Dummies"

I have a large simple list of words in Word 2007 that I wish to export to
Excel 2007.

The list is like the following with no punctuation:

Duck
dog
turkey
frog
dance

How do I prepare this list so I can do the export/import thing?

Thanks

-*-
Jim Curts

 

[JoAnn Paules]

Do you have full returns after each item? Try copy and paste special.

--

JoAnn Paules
MVP Microsoft [Publisher]
Tech Editor for "Microsoft Publisher 2007 For Dummies"

Yes, and it all ended up in one cell.

I finally tried an old online trick of saving the file as an .mht file
and it exported perfectly to Excel.

I realize there must be a more civilized method to to accomplish
this and am interested in learning of it.

Thanks

-*-
Jim Curts

Did you try a simple copy and paste?

--

JoAnn Paules
MVP Microsoft [Publisher]
Tech Editor for "Microsoft Publisher 2007 For Dummies"

I have a large simple list of words in Word 2007 that I wish to export to
Excel 2007.

The list is like the following with no punctuation:

Duck
dog
turkey
frog
dance

How do I prepare this list so I can do the export/import thing?

Thanks

-*-
Jim Curts

 

[Suzanne S. Barnhill]

It might help to convert the list to a table first. Insert | Table | Convert
Text to Table (making sure that 1 is shown for the number of columns in the
ensuing dialog).

 

[Wickiup]

I don't really know. I just did the copy and paste thing from a web page.

Perhaps pasting to Note pad then redoing the copy paste thing may have done
the trick.

-*-
Jim Curts

Do you have full returns after each item? Try copy and paste special.

--

JoAnn Paules
MVP Microsoft [Publisher]
Tech Editor for "Microsoft Publisher 2007 For Dummies"

Yes, and it all ended up in one cell.

I finally tried an old online trick of saving the file as an .mht file
and it exported perfectly to Excel.

I realize there must be a more civilized method to to accomplish
this and am interested in learning of it.

Thanks

-*-
Jim Curts

Did you try a simple copy and paste?

--

JoAnn Paules
MVP Microsoft [Publisher]
Tech Editor for "Microsoft Publisher 2007 For Dummies"



I have a large simple list of words in Word 2007 that I wish to export
to Excel 2007.

The list is like the following with no punctuation:

Duck
dog
turkey
frog
dance

How do I prepare this list so I can do the export/import thing?

Thanks

-*-
Jim Curts

 

[Wickiup]

Was sure hoping not to do that as this will be edited
by a number of folks across this fair land we live in and
there will be several more colums in which to add relavant
data.

-*-
Jim Curts

 

[Graham Mayor]

If you copy material from the web, or from this message, the line endings
are line breaks and not paragraph breaks. A section of text with line breaks
is treated as a single paragraph and so a standard paste will put the
paragraph in a single cell. To separate the list into rows, use Edit > Paste
Special > Text. (In Excel 2007 Paste special is on the tiny arrow adjacent
to the Paste button on the Home tab).

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

I don't really know. I just did the copy and paste thing from a web
page.
Perhaps pasting to Note pad then redoing the copy paste thing may
have done the trick.

-*-
Jim Curts

Do you have full returns after each item? Try copy and paste special.

--

JoAnn Paules
MVP Microsoft [Publisher]
Tech Editor for "Microsoft Publisher 2007 For Dummies"

Yes, and it all ended up in one cell.

I finally tried an old online trick of saving the file as an .mht
file and it exported perfectly to Excel.

I realize there must be a more civilized method to to accomplish
this and am interested in learning of it.

Thanks

-*-
Jim Curts


Did you try a simple copy and paste?

--

JoAnn Paules
MVP Microsoft [Publisher]
Tech Editor for "Microsoft Publisher 2007 For Dummies"



I have a large simple list of words in Word 2007 that I wish to
export to Excel 2007.

The list is like the following with no punctuation:

Duck
dog
turkey
frog
dance

How do I prepare this list so I can do the export/import thing?

Thanks

-*-
Jim Curts

 

[Graham Mayor]

Record a macro in Excel using paste special as previously suggested and add
a toolbar button to Excel to activate it (if using the built in command is
too much of an effort).

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

 

[Suzanne S. Barnhill]

I don't understand what you mean. I was suggesting that you convert the text
to a table before pasting it into Excel. But it seems the problem is that
you have lines ending in line breaks rather than paragraph breaks, so you
wouldn't be able to convert to a table, either, unless you replaced the line
breaks with paragraph breaks first.

 

[Wickiup]

Thanks, I understand all of that now.
I had not used either of these programs before taking off on this adventure.
It was a project that had to be done and I did what I needed to get it done
in a time,y manner.
Thanks to all of you good folks on here I can approach these issues a bit
more knowledgeably in the future.

-*-
Jim Curts

If you copy material from the web, or from this message, the line endings
are line breaks and not paragraph breaks. A section of text with line
breaks is treated as a single paragraph and so a standard paste will put
the paragraph in a single cell. To separate the list into rows, use Edit >
Paste Special > Text. (In Excel 2007 Paste special is on the tiny arrow
adjacent to the Paste button on the Home tab).

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

I don't really know. I just did the copy and paste thing from a web
page.
Perhaps pasting to Note pad then redoing the copy paste thing may
have done the trick.

-*-
Jim Curts

Do you have full returns after each item? Try copy and paste special.

--

JoAnn Paules
MVP Microsoft [Publisher]
Tech Editor for "Microsoft Publisher 2007 For Dummies"



Yes, and it all ended up in one cell.

I finally tried an old online trick of saving the file as an .mht
file and it exported perfectly to Excel.

I realize there must be a more civilized method to to accomplish
this and am interested in learning of it.

Thanks

-*-
Jim Curts


Did you try a simple copy and paste?

--

JoAnn Paules
MVP Microsoft [Publisher]
Tech Editor for "Microsoft Publisher 2007 For Dummies"



I have a large simple list of words in Word 2007 that I wish to
export to Excel 2007.

The list is like the following with no punctuation:

Duck
dog
turkey
frog
dance

How do I prepare this list so I can do the export/import thing?

Thanks

-*-
Jim Curts

 

[Wickiup]

Using a command is not too much effort. I just am not familiar with
the program I had to use to accomplish the task.

-*-
Jim Curts

 

[Wickiup]

I'm not certain what formatting was involved. But now that time is not a
limiting factor and I can assimilate what you folks have presented I will
approach these non standard issues more knowledgeably.
It will also not be my first time using these programs.

Thanks

-*-
Jim Curts