In this lecture I’ll show you how easy it is in Power Query to extract and transform text compared to using Excel formulas. 

If you have Excel 2016 or 2019 and don't have the "Split Column by Digit to Non-Digit" option, you can extract the ID using Column From Example.