You use Office Excel 2010, the spreadsheet software from Microsoft, to create complex documents that can contain tables. Access 2010, the database software from Microsoft, also contains tables.

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