Hi, I'm making an English teacher making quizzes based on lists of sentences with translations.
I want to make one formula that takes the text string of another cell and randomly replaces one word with an underscore ____.
I'd also like to make a formula that replaces all the words with underscores.
Examples below.
[I know it's possible to find words by counting spaces, my bigger challenge replace the found words.]
<colgroup><col><col></colgroup><tbody>
</tbody>
I want to make one formula that takes the text string of another cell and randomly replaces one word with an underscore ____.
I'd also like to make a formula that replaces all the words with underscores.
Examples below.
[I know it's possible to find words by counting spaces, my bigger challenge replace the found words.]
Input Sentence | Output Question |
I am happy. | I ____ happy. |
We all enjoy our work. | We all _____ our work. |
The team is very good. | The team is ______ good. |
It is my favorite. | ____ ____ ____ ____ |
They didn't come in yet. | ____ _____ ____ ____ _____. |
Why are you going there with them? | _____ ______ _____ ____ ____ ____ ____? |
<colgroup><col><col></colgroup><tbody>
</tbody>