Forum Discussion
Solved
DataFormat.Error #N/A and #DIV/0!
I am bringing in an Excel file source that is generated from an export in an application and some of the fields have this in the extract, #N/A and #DIV/0!. They are not formulas, just text in a field. Any way to fix this in PowerQuery instead of the source?
4 Replies
Razorbx13, in Power Query, right-click the column and choose Replace Values. Enter the text to be removed in "Value to Find" and click OK.
Razorbx13 , In power Query you can right click on the column and replace the values.
You can also use replace function of Power Query : https://www.howtoexcel.org/power-query/bulk-replace-values/
