Thread: How to copy specific font text from Word to Excel?
View Single Post
 
Old 07-24-2023, 06:26 PM
syl3786 syl3786 is offline Windows 10 Office 2019
Advanced Beginner
  
Join Date: Jan 2023
Posts: 97
syl3786 is on a distinguished road
Default
Quote:
Originally Posted by Guessed View Post
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
Thanks for your reply! Can it be done by using VBA? Since I have lots of documents to handle, a VBA button can help me to do it faster.

Thanks again for your suggestions.
Reply With Quote