Replace cell values with PowerQuery blank values

[XaviOV]

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

[jairoaol]

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)

[amitchandak]

@XaviOV ,

refer

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

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

[XaviOV]

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

[v-easonf-msft · Accepted solution]

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.

[amitchandak]

@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/