Let's Compare Power Query Functions and Excel Formulae

Comparison of Text Formulas in Excel and in Power Query