Automating Text extraction of strings between two special characters in microsoft word to excel Columns

I want to automatically extract text from word into excel columns based on sections separated by special characters.

Ex:

Extracting all data from between @ and ! into a specified excel column. Lets say titles.

@

Word

Excel

Powerpoint

!

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 !

Hi @jazir5

This link maybe usefull to you.

cheers :smiley:

Happy learning :smiley:

2 Likes