Multiple find and replace in MS Word from a list in MS Excel

0 votes
Since I've been attempting to do this for a while without much success, I truly hope you can assist me. I have an Excel list, let's say file 1. (say, A1 - B10, 2 columns of words - the words in column A are the ones to be replaced by the ones in column B).

I have a word document, let's say file 2, and I want to run the words through an excel file such that each time a word from column A appears in the document, the term from column B is used in its stead.

Please know that I would greatly appreciate any assistance you could provide.
Oct 28, 2022 in Others by Kithuzzz
• 27,940 points
83 views

1 answer to this question.

0 votes
If I understand you correctly, you want to swap out certain words in your Word document with those found in your Excel file.

Then the macro for it can work. Hope this is helpful.
answered Oct 28, 2022 by narikkadan
• 51,600 points

Related Questions In Others

0 votes
1 answer

In Excel, how to find a average from selected cells

If one has the dynamic array formula ...READ MORE

answered Oct 9, 2022 in Others by narikkadan
• 51,600 points
150 views
0 votes
1 answer

How can I scrape a excel file from a website and divide it in different parts?

Use Scrapy or beautifulsoup4 parsing data it's more convenient ...READ MORE

answered Jan 13 in Others by narikkadan
• 51,600 points
41 views
0 votes
1 answer

How to open .xlsx files in MS Excel from VS Code?

Hello, to open xlxs files, or files ...READ MORE

answered Feb 17, 2022 in Others by gaurav
• 22,940 points
558 views
0 votes
1 answer
0 votes
1 answer

Excel VBA - Subscript Out of Range Error (Run Time: Error 9)

Set rangePartner = Range(Partner.Cells(2, 2), Partner.Cells(2, 2).End(xlDown)) Needs ...READ MORE

answered Jan 21 in Others by narikkadan
• 51,600 points
36 views
0 votes
1 answer
0 votes
1 answer

Examples for string find in Python

you can use str.index too: >>> 'sdfasdf'.index('cc') Traceback ...READ MORE

answered Aug 29, 2018 in Python by Priyaj
• 58,100 points
354 views
0 votes
1 answer
0 votes
1 answer

How can I find and replace text in Word using Excel VBA?

Try this code Option Explicit Const wdReplaceAll = 2 Sub ...READ MORE

answered Oct 15, 2022 in Others by narikkadan
• 51,600 points
268 views
0 votes
1 answer

How to unmerge multiple cells and transpose each value into a new column in Pandas dataframe from excel file

Try this: df = pd.read_excel("Sample_File.xlsx", header=[0,1,2,3,4,5], index_col = ...READ MORE

answered Jan 8 in Others by narikkadan
• 51,600 points
91 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP