automate find & replace

J

jasemhi

I have the following columns that I want to do an automated find and
replace on:

_JapaneseCompound_EnglishMeaning_JapaneseID_EnglishID_
# number # 321
? question ? 322

I would like to replace the column JapaneseCompound with the column
EnglishID, based on finding the JapaneseID, and I want to do this for
all rows. For expamle for row 1;

find (JapaneseID) #
replace (EnglishID) 321

then for row 2;

find (JapaneseID) ?
replace (EnglishID) 322

How can I do this?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Improving Macro That Keeps First Letter 0
Removing a repeated words 0
Disable Outlook AutoCorrect with GPO 0
Word macro that can call cells out of Excel for a find and replace 0
Keep First Letters, with exceptions 0
WORD VBA Search and switch to advanced ... 1
Find and Replace 6
How can I find paragraph breaks that are not preceded by a period? 0

Top