find a word, within many words/columns and put a copy in anothe co
 

find a word, i.e., (AA), within several columns of words and find all
occurances where ever the word is found in the word, beginning through end,
and make a copy of the answer in another column, using visual basic or macro.