Hi,
I'm trying to save myself typing, and here is what I want to do to this work sheet. (Two possibilities..)

1. If I could sort and paste the text I want in the adjacent cells that would be great...but I can't undo only the sort after copying and pasting, can I?

Or

2. Is there a formula that would for example if cell B2 was "Hello" then A2 would automatically insert a word of my choice throughout the rest of the whole worksheet? Or if "Hello" was in this cell, the text I want returned would be in the cell to its left?

Thank you,
JB