View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
philr philr is offline
external usenet poster
 
Posts: 10
Default extracting data in Word for Excel

Using Office 2003

Im creating an Excel file to upload a few thousand text clinic notes
previously written in Word to an EMR system. On the Excel end I need a
separate record for the patient name, Med number, date of service and the
actual text. With the generous help of MVPs here I have been able to place
the body of each persons note into a corresponding single cell.

Ive combined many of the thousand files on the Word side into several .doc
files and am prepared to copy to Excel and manipulate the text.

Is there a way I can create 3 identifying characteristics within the Word
text file (.doc) for each patient name, med number, and date of service so
that Excel can find and copy the patient name into the same record patient
name column, the med number into the med number column, and the date of
service into the DOS column? Separate steps are fine.

I would like to avoid doing this in Excel exclusively since the cell text
takes up most of the screen when the cursor is in the cell and it appears to
be harder to navigate within the cell.

I cant use underline or bold since these are used extensively in the Word
files. Style?

Thank you,
philr