This time the challenge before you is to write a formula that if a sentence is given in A1, your formula if dragged to the right should split the sentence into words.
Remember, it has to be a single formula which should be put into B1 and dragged to the right.
See the examples below –
A workbook containing this challenge can be downloaded from Challenge 42 – Split a Sentence Into Words in Different Cells
The solution to above challenge will be published on 7-Jun-16.