This post explains how to use the new Excel TEXTSPLIT function ... as shown in the above image. Excel will split the text string on the basis of 2 delimiters here: full stop ...