Extracting Data from a table

M

Maurice

Greetings:

Working with Office 2003. Copied a table from a website to get figures
from a single column. Able to delete unecessary columns but don't know how
to separate the numbers from the colum of interest. Would like to get this
in CSV. I am assuming that the souce table was created in word but cannot be
certain. Guidance sought.
 
H

Herb Tyson [MVP]

The source really doesn't matter. Do you have the numbers in a Word table
now, after pasting? If the talbe has multiple columns, copy & paste into
Excel, and from there you can save as .csv format.

Or... if it's only a single column of numbers, then the "c" (comma) in CSV
doesn't matter. You can save directly from Word in text format, naming the
file as .csv (put whole name in quotes to avoid getting the default .txt),
if you really need that extension.
 
Top