View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
JM
 
Posts: n/a
Default Need help getting data from Word to Excel

I'm novice level with Word and Excel, so excuse what may be a basic
question/problem that I've got.

I asked an employee to enter lots of data into Excel. The data is company
name, address, contact name, and phone number. I requested that each type
of data be entered into different columns. Instead, the employee used MS
Word 2003. To compound the issue, the employee did not use commas, tabs, or
any other delimiter or formatting method that might allow me easily to get
the data over into Excel (by *easily* I mean using a technique that I know
; ) The data in Word simply is separated by random numbers of spaces.
Nothing lines up, either, so I can't use the manual column markers in
Excel's Open As wizard.

What are my options for getting the data into Excel with the 4 categories in
separate columns? There are several hundred rows of data.

Thank you,

JM