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

If you have users who prefer to push Excel data into Outlook instead of importing it from inside Outlook, try this VBA event procedure.