Find *ALL* words with Find & Replace tool?

[BigDataGeek]

I'm looking to find *any* words from my replace input that are in the find input and append the words found.  From what I can see, it only finds the first instance and stops.  Is there a way to use this tool to scan for all words in the replace input?   

I have way too many words in the replace input to do multiple find & replacement tools. 

basic example attached.

[alexnajm]

You'll have to break it out into its components, use the find replace, and piece them back together. Example attached that works well!

[Qiu]

@BigDataGeek 
I think you are right.

So do you accept the Batch Macro?

[flying008]

Hi, @BigDataGeek 

Like this ?

[BigDataGeek]

interesting approach.  Can you share the workbook?

[BigDataGeek]

Thanks @Qiu !  

I'll research this option.  

[Swathi]

Glad to see multiple options here 

I tried to use Iterative macro