PowerQuery (Blank)

[gavs73]

Hi, would appreaciate any pointers on this, I'm importing some Data into PowerQuery for PowerBI from SQL, and in one of the Columns I have some that are (Blank) I've tried to do Replace Values and Put (Blank) and Replace with 'Unknown' but it doesn't recognise (Blank), I assume it is looking for it literally. Is there a trick to replace the (Blanks) ? Thanks for your help. Gav

 

[mart37]

Have the cells blanks or null value?
You can try replace null with unknown.

 

[gavs73]

Hi, thanks for your help, the are Empty rather than Null, I have Nulls too, not sure how to reference (Blank)