I am looking for a web service or application that can combine words randomly. Excel?
7:00 am in SOA Answers by admin
I am looking for a web service or application that can, simply, take a word from three sets of imported words and combine them randomly. I know there is a "concatenate" function in Excel but I don’t know how to get the random part in there. Any thoughts? Thanks in advance.
This formula in Excel will take a random string of 3 words from 3 columns of 100 words (1 word from each). It will put a space between each word. Adjust the 100 value to match the number of words.
Say you have 100 words in Cols A, B & C, in D1 put
=INDIRECT("A"&INT(RAND()*100)+1)&" "&INDIRECT("B"&INT(RAND()*100)+1)&" "& INDIRECT("C"&INT(RAND()*100)+1)