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
• 38,020 points
640 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
• 63,720 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
• 63,720 points
696 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, 2023 in Others by narikkadan
• 63,720 points
597 views
0 votes
1 answer

Python write a list to multiple columns in excel

Make a nested list : L = [list1, list2, list3] Then ...READ MORE

answered Mar 30, 2023 in Others by narikkadan
• 63,720 points
3,997 views
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, 2023 in Others by narikkadan
• 63,720 points
958 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
758 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
• 63,720 points
4,760 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, 2023 in Others by narikkadan
• 63,720 points
2,393 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