Excel: How to use TEXTSPLIT function

There are a number of ways to split text from a cell into multiple cells such as splitting someone's name into first and last name.TEXTSPLIT is the latest function to do this and it does add extra functionality.

There are some other recent text functions added including:

I am an Amazon an Techsmith affiliate and might earn when purchasing from any of these links. However, this does keep my free tutorials to you going.

[TheLookingOne]

Thank you jfh !
How can you restore the delimiter in TEXTSPLIT splits before the last split?
For example, when splitting 3 sentences in one paragraph and using the ". " delimiter, only the third sentence retains the ". " delimiter.
Unfortunately, the pad_width parameter does not retain those delimiters with TEXTSPLIT(B2, , ". ", , , ". ")
How does the pad_width parameter function?
Cheers,