🧠 You've learned essential text transformation techniques:

• Split columns by delimiter (including custom delimiters)
• Split columns by non-digit to digit and digit to non-digit
• Add prefix to columns
• Extract text before delimiter
• Extract text after delimiter with advanced options (scan from end of input)
• Capitalize each word
• Duplicate columns

💡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.

💡The formula route is not as complex as it used to, with new formulas introduced in Excel for Microsoft 365: TEXTSPLIT and TEXTBEFORE/TEXTAFTER replicate the functionality of Power Query's Split Column and Extract Text. (Only available in Excel for M365 and Excel 2024.)