LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Extracting specific data from inconsistant multiple word documents Matt Bennette[_2_] Excel Discussion (Misc queries) 4 January 5th 09 01:30 PM
Extracting Text from Embedded Word Documents in Excel Marc C Excel Programming 1 March 22nd 07 04:17 AM
Excel extracting Headers and Body text from MS Word spences10 Excel Programming 1 January 29th 07 01:33 PM
Extracting info from word and displaying in an excel spreadsheet Drew Excel Discussion (Misc queries) 0 March 7th 05 03:49 AM
Extracting Data from Word to Excel. jk Excel Programming 2 January 13th 05 08:13 PM


All times are GMT +1. The time now is 12:29 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"