Extracting Text Before Delimiter

[Anonymous]

I created a new column in Power Query by extracting "Text Before Delimiter". During my audit, there is a field within the column that I would like to update: "NULL" = [BLANK]. How would we be able to do that in Power Query? Below is sample data: Table 1 = Current Output / Table 2 = Expected Output. 

(Table 1 = Current Output)

Labels	Labels Bucket
NULL	NULL
1,2	1
2,3,4	2
15,99,2000	15

(Table 2 = Expected Output)

Labels	Labels Bucket
NULL
1,2	1
2,3,4	2
15,99,2000	15

Any advice is greatly appreciated. 

[amitchandak]

@Anonymous , Try a new column

try one of the two

=Text.Replace("Null", null)

=Text.Replace("Null", "")

[Anonymous · Accepted solution]

@amitchandak  Thank you for your support. I tried your suggestion but could not figure out how to add the command. After playing around with the column, "REPLACE VALUE" worked great. 

Once again, thanks for your support!