Download Excel File: https://excelisfun.net/files/EMT1736.xlsx
Learn how to extract an ID number between a start and end space delimiter.
Topics:
1. (00:00) Introduction
2. (00:32) Worksheet Formula with 6 functions.
3. (02:21) LET function to remove formula elements that are repeated.
4. (03:50) Worksheet Formula with 5 functions.
5. (04:47) INDEX and FILTERXML function example.
6. (05:17) Power Query Extract Between Delimiters.
7. (05:58) Summary, Closing and Video Links