Using some relatively simple VB coding syntax, you can design a command button or other control option to create a new workbook and export data to it for use in Excel.

Learn how to use Excel Power Query's extract and split column features to extract delimited strings into their components.