ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Extract data (not in table) from Word to Excel (https://www.excelbanter.com/excel-discussion-misc-queries/65129-extract-data-not-table-word-excel.html)

hellokitty77

Extract data (not in table) from Word to Excel
 
I'm trying to find a way to tag free text in Word and then auto extract
all the tagged text into an Excel spreadsheet. Does anyone have any
suggestions?


Martin P

Extract data (not in table) from Word to Excel
 
Tag the text by bolding it. Go to Edit, Replace and replace bold text with
Find What Text/// (the field shows ^&///). Remove text that is not bold by
replacing bold text with nothing. Replace /// with paragraph marks. Change
Bold to Not Bold. Copy what you have left to Excel.
If there is already bold text in the document you can choose another font
that is not in the document, or you can use Marching Black Ants.

"hellokitty77" wrote:

I'm trying to find a way to tag free text in Word and then auto extract
all the tagged text into an Excel spreadsheet. Does anyone have any
suggestions?




All times are GMT +1. The time now is 10:06 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com