To fix DataFormat.Error, We couldn't convert to Number, when working with data in Power Query, whether in Excel or Power BI use these solutions ...

Learn how to extract specific data from Excel cells using formulas, tools, and techniques to clean and organize messy datasets.