Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Extracting specific data from inconsistant multiple word documents | Excel Discussion (Misc queries) | |||
Extracting Text from Embedded Word Documents in Excel | Excel Programming | |||
Excel extracting Headers and Body text from MS Word | Excel Programming | |||
Extracting info from word and displaying in an excel spreadsheet | Excel Discussion (Misc queries) | |||
Extracting Data from Word to Excel. | Excel Programming |