PDA

View Full Version : Extracting resume data from word to excel



medic989
10-05-2016, 12:54 PM
Hi All,

I am in need of extracting out names, addresses, email, phone numbers & major from a hundreds of different resumes all in one file and put into excel table for easier use. Is there a macro that can help me achieve this? Here is a sample of the data. Note that each resume could be formatted differently.


Thanks,

Z

snb
10-05-2016, 01:17 PM
Save the Wordfile as .txt file.
Open the txt file in Excel.
After that we can create a macro.

medic989
10-05-2016, 01:29 PM
Okay, I have done the above. For the sample data, there is also experience on the resumes that is not needed. Will the macro be able to delete this information? What are the next steps?