View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Rebecca
 
Posts: n/a
Default Search and Replace

Oh, and to reply to my own post, if you think it strange to be doing
something this in Excel, there is a reason I'm using it instead of, say,
Access or the like. I realize Excel is mostly used for calculating and the
like, but after each word is translated into English, there will be some
calculations done here and there.

"Rebecca" wrote:

Greetings. Is this possible in Excel 2007 (beta)? I have four columns: A,
B, C, and D (which is blank). If the word in a particular row in A is "hat,"
the word in the same row in B is "bug," and the word in the same row in C is
"flower," I want to place the word "tree" in the same row in blank column in
D. I want this to happen to all the rows with this particular combition
(hat, bug, and flower). Of course, I will go through the spreadsheet row by
row to fill in all the words. This is a translation exercise, with A (the
Hebrew word), B (the parsing), and C (the dictionary form of the word in A)
words in one langauge (Hebrew), and D will be the translation of the words
(in English). I hope this will not involve complicated programing or macro
building, because I am a new user. If this is possible, and if so could you
please explain to me how to do this, and in simple English, step-by-step?
Thanks.