automate find & replace
 

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

_JapaneseCompound_EnglishMeaning_JapaneseID_Englis hID_
# 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?



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/