I want to automatically extract text from word into excel columns based on sections separated by special characters.
Extracting all data from between @ and ! into a specified excel column. Lets say titles.
To the excel column (MS Office program titles)
I want to do this on a repeated basis throughout the entire 243 page document to sort the entire doc into spreadsheet format.
Anyone know how i can do this?
There will be 5 different columns and 95 separate items that each get their own row. Each column for each item in excel will be between the same 2 symbols. Ex: Prices will always be between @ and !