Splitting Text into Parts
There is an Excel file that teaches how to perform the Splitting Text into Parts operation.
Excel-Based Splitting Text Into Parts
This workbook demonstrates splitting text into parts using VBA macros on a 10-row data layout.
Hope it is useful.