Replacing Empty

[stribor45]

I have a few of the empty values which I can't replace because it is forcing me to enter something in replace values. Any suggestions?

[Anonymous]

Hi @stribor45 

Based on the picture you offered, your column type is number, based on this type, if your column is blank, it will display 'null' automatically, you can not replce the value to type because the null is existed in the column.you can consider to replace the blank with 0.

Best Regards!

Yolo Zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[stribor45]

i did select the right column but did not trim anything. Would would I need to trim it?

[Einomi]

Did you select the right column ?
Did you try to trim the column ?

[stribor45]

yes i did select the right column but why is trim needed?