I am using Excel, and am running into a problem that leads me to believe there might be a macro or other solution for this. Hand editing is tedious! :)
I am looking use the find/replace (or something else) tool in excel to do the following:
- find a word in some nth row (the word will be found in column 1 of that row)
- put a new (previously defined) word in the same row, but into the cell for column 2
Is this possible?