Forum Discussion
Solved
Replace cell values with PowerQuery blank values
Hello I would like to know what the steps in PowerQuery would be to replace values with values that were white (cell without data). Thank you! Xavi
Hi， XaviOV
What data type is your column?
If you column type is number,it will show "null" when there there is no data in cell (defalut).
If you column type is text,it will show " " when there is no data in cell.
If you column type is text and a lot of cells with the value null,please right click the column ->replace values as below.
Then it will be changed to Blank.
Best Regards,
Community Support Team _ Eason
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
right-click replace values in the required column
in the first field you set the text to change
in the second field you can leave it empty or null (in handicaps)