Forum Discussion

Helper V

6 years ago

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

v-easonf-msft
6 years ago
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.
pbix attached

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.

Super User

6 years ago

refer

https://www.excelcampus.com/powerquery/fill-down-blank-null-cells-power-query/

https://www.youtube.com/watch?v=-fwKhMot9hw

Helper V

6 years ago

Hi amitchandak
I have a lot of cells with the value null , and I want to change it to Blank, I want that the cell contains anything.
Regards,
Xavi

amitchandak
Super User
6 years ago
XaviOV , if it the text "null", the use replace with null as empty. if it null, the empty one no need has this same as blank.

or use text.replace

https://docs.microsoft.com/en-us/powerquery-m/text-replace

https://www.howtoexcel.org/power-query/bulk-replace-values/
v-easonf-msft
Community Support
6 years ago
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.
pbix attached

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.