lundi 4 janvier 2016

Can I use Excel function to generate a random word from sentences?

Could anybody shows a function to get a random word from a sentence in Excel. I am making a Gap fill exercises. With Column A1 contains the long list of sentences (each sentence is on one row). I need to get column B1 contains list or random word from each sentences from A1. I've been searching around for quite a while but haven't found anything possible. Plus, if it could be done in Excel, the speed is way faster than the others. I think.




Aucun commentaire:

Enregistrer un commentaire