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

**faizzsheikh** · 03-09-2016, 12:52 PM

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.

**mehmetcik** · 03-09-2016, 12:54 PM

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachements to open the upload window.

View Pic

**dosydos** · 03-09-2016, 01:16 PM

Add a helper column to column A. label your phrases 1-1100 (or however many phrases you have).

Column B are your phrases
column C are your Terms
i put the formula in cell D2. change references where applicable. recalculating, changin widths of columns, or pretty much anthing else randomizes this formula constantly so if you need it to be static, copy and paste values.
In the formula below i have two instances of 1100 please change the 1100 too what ever the last number in column A is.

=IF(RANDBETWEEN(0,1)=0,C2 & " " & VLOOKUP(RANDBETWEEN(1,1100),A:B,2,FALSE),VLOOKUP(RANDBETWEEN(1,1100),A:B,2,FALSE) & " " & C2)

**faizzsheikh** · 03-09-2016, 01:47 PM

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)

**faizzsheikh** · 03-09-2016, 01:37 PM

Thanks for your reply mehmetcik

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

Thanks for your support

**dosydos** · 03-09-2016, 01:47 PM

trythis should work for you

**faizzsheikh** · 03-10-2016, 05:53 AM

Thanks a lot dosydos for the help!

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

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

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

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

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

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

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

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

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

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

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Autocomplete search word based on Initial first/random word

Adding a random prefix and suffix to a cell

[SOLVED] Search using a Word/Phrase

[SOLVED] Unique Random Words From Word List

Calculating cells that include a specific word but not another word

Highlighting a word or phrase

Identifying most recurring word or phrase from a list of remarks in excel

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions