Forum Discussion
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.
5 Replies
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,
XaviXaviOV , 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
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)
