Forum Discussion

Razorbx13's avatar
Razorbx13
Icon for Post Patron rankPost Patron
6 years ago
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 fiel...
Need Help
  • negi007's avatar
    negi007
    6 years ago

    Razorbx13  In power Query window, use replace error to replace error with a default value

     

     

DataInsights's avatar
DataInsights
Icon for Super User rankSuper User
6 years ago

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.