| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can I copy a table from Word into one cell in Excel without losing data? (Office 97) | Excel Discussion (Misc queries) | |||
| Linking table in Excel to word | Links and Linking in Excel | |||
| TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER | New Users to Excel | |||
| How can deleted data reappear in a refreshed pivot table in Excel | Excel Discussion (Misc queries) | |||
| Getting specific data from a word document into an excel sheet | Excel Worksheet Functions | |||
Linear Mode
