Word Data to Excel

[Brian Salerni]

I have to convert all of the US cities in each state, from a Word document to Excel. I'll need each city to convert to a separate cell.

In college I remember doing this, however I don't remember the formula. Needless to say, this will save me a ton of time!




Submitted via EggHeadCafe - Software Developer Portal of Choice
Treeview Explorer / Dialog for SmartPhone
http://www.eggheadcafe.com/tutorial...29-8f0336e05a0a/treeview-explorer--dialo.aspx

 

[Otto Moehrbach]

What is the layout in the Word document? Are the cities on separate lines?
If so, do those lines contain anything other than the cities' names?
Lines in Word will be placed in individual cells in Excel when copied. What
do you get when you copy & paste into Excel? HTH Otto
in message news:[email protected]...

 

[Brian Salerni]

For example, i will be copying and pasting cities from a site like so:

http://www.50states.com/zipcodes/southdakota.htm

Any thoughts?



Otto Moehrbach wrote:

What is the layout in the Word document? Are the cities on separate lines?
24-Jan-10

What is the layout in the Word document? Are the cities on separate lines
If so, do those lines contain anything other than the cities' names
Lines in Word will be placed in individual cells in Excel when copied. Wha
do you get when you copy & paste into Excel? HTH Otto

Previous Posts In This Thread:


Submitted via EggHeadCafe - Software Developer Portal of Choice
Dr. Dotnetsky's Cool .Net Tips & Tricks #20
http://www.eggheadcafe.com/tutorial...8427-53b4add41242/dr-dotnetskys-cool-net.aspx

 

[Otto Moehrbach]

If you have 3 columns in Word like you show, you will have one column in
Excel. Each cell in Excel will contain the 3 cities from each word line.
So say you paste it into column A starting in A1. In B1 (or any cell in the
first row to the right of column A) type this formula:
=Trim(A1)
Drag this formula down, by the fill handle, as far as your data goes. This
will give you 3 cities in each cell with only one space between cities.
Copy column B and PasteSpecial - Values into A1. Delete column B.
Now do Text-To-Columns on Column A. Look it up in Help. This will get you
3 columns, each with one city. Come back if you need more. HTH Otto

in message news:[email protected]...

 

[macropod]

Hi Brian,

Your original post said you need to transfer the data from Word to Excel. What you now seem to be describing is capturing data from
a web page. Which is it?

--
Cheers
macropod
[Microsoft MVP - Word]


in message news:[email protected]...