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

Importing data from Excel to SQL Server requires going back in time, so to speak. Yes, back to 32-bits at runtime.