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?
 
Top