Replace word in table - power queary (all columns)

[Recoba88]

Hi,

I want to replace the word "NULL" to ""

in all columns of the table without using name of each column

Anyone?

[MarcelBeug · Accepted solution]

Replace the list of column names by:

Table.ColumnNames(#"Changed Type1")

Edit: are you sure about the "NULL"? I would expect null.