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