Splitting Data by Character
There is an Excel file that teaches how to perform the Splitting Data by Character operation.
Excel Format: Splitting Data By Character
This workbook splits cell text by a specified delimiter character using VBA on a 3-row example dataset.
Hope it is useful.