#1
|
|||
|
|||
How to copy specific font text from Word to Excel?
Hi everyone,
I'm currently working on a project where I need to copy specific text from a Word document to an Excel spreadsheet. The text I need to copy is in a specific font (let's say it's "Arial"), and it's scattered throughout the tables of the document. Does anyone know of a way to copy just the text in a specific font from a Word document to an Excel spreadsheet? I'm open to using VBA or any other methods that might work. Thanks in advance for your help! |
#2
|
||||
|
||||
This method works for me.
1. Open the Find and Replace dialog by pressing Ctrl-H 2. Go to the Find tab in that dialog and in the Find what box, set the format to Font = Arial 3. Find in > Main Document (all the found instances should be selected) 4. Close the dialog by clicking the X in the top corner 5. Copy selected text by pressing Ctrl-C 6. Go to Excel and Paste
__________________
Andrew Lockton Chrysalis Design, Melbourne Australia |
#3
|
|||
|
|||
Quote:
Thanks again for your suggestions. |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Need to copy specific formated text from Word and paste from clipboard into a console application | Userx | Word VBA | 0 | 10-09-2020 05:58 AM |
Linking Specific text fields in PP to specific cells in an Excel table | GWRW1964 | PowerPoint | 0 | 02-26-2018 07:37 AM |
How to change the font color of specific text within a Word table cell | epid011 | Word Tables | 2 | 05-15-2017 05:21 PM |
Insert Text with specific Font Size | Nick70 | PowerPoint | 1 | 08-10-2016 09:56 AM |
copy a specific words to excel list | romanticbiro | Word VBA | 12 | 12-03-2014 05:12 AM |