Extracting resume data from word to excel

[medic989]

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]

Save the Wordfile as .txt file.
Open the txt file in Excel.
After that we can create a macro.

[medic989]

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?