Breaking paragraph into separate phrases and putting each phrase in separate rows

Try this attachment on for size--

This ended up being 2 x n (well, 3 x n, but the first is a superfluous column that exists for the reader, not for the functions; delete it without worries if you'd like). The first column finds the next punctuation mark you're interested in with SEARCH, and the second column slices out everything between that mark (inclusive) and the last one (exclusive).

If you really truly need it to be a true array of 1 x n elements, than in the second column, just replace every reference to a cell in the first column with the content of that cell. The formulas will get pretty ugly looking and long, but w/e.

Thanks Ben..! It's working perfectly.. infact i could add more number of separators in the code you have provided and further improvise on the result.

Thanks very much again.


Warm Regards,
Shashank