Include random word from the word list with a phrase as suffix or prefix

Hi Everyone,

Need your help again

I have a column with a list of Phrases (about 11000 count) which are actually product names. I want to add a suffix or prefix (randomly) to these phrases from a Group Of Terms (about 20-30 count)

Phrases
Column A

Power Bank 500 MAH
2200 mAh Portable Re-Chargeable Power Bank Battery
Bluetooth Speaker And Tablet Stand
Cubic Bluetooth Speaker
Wireless Induction Speaker
Zabrak Powerbank Bluetooth Speaker

Group Of Terms

Custom Printed
With Logo Imprinted
Customized Promotional
With Custom Personalization


--------------

Example Result:

Custom Printed Power Bank 500 MAH
Bluetooth Speaker And Tablet Stand With Logo Imprinted
Wireless Induction Speaker With Custom Personalization


Hope there is a way to do this using excel functions.

Thanks for your reply mehmetcik

I have attached a sample workbook with example showing in the "before" and "after" sheet.

Thanks for your support

Hi Dosydos,

Thanks a lot for this help. The function is working, perhaps if the prefix term gets added as suffix the phrase become meaningless.

If we divide phrases in two groups 550 with random 'suffix only' and 550 with random 'prefix only'. This way I assume there will be two different function to use, one for each group (suffix and prefix)

trythis should work for you

Thanks a lot dosydos for the help!

This forum is full of geniuses, I love spending time here