Can you give us some examples of the content of the original cell and what you
want in the cells as a result of the use of the function. Is it something
like:
Original cell A7 contains "Mary had a little lamb"
After application of function
Cell B7 Contains "Mary"
Cell C7 Contains "had"
Cell C8 Contains "a"
Cell C9 Contains "little"
Cell C10 Contains "lamb"
We need to understand what you need exactly. Then we may be able to help.