Text to column changes empty to null?

[Hamder83]

Hi 

Howcome text to coloumns changes a empty cell to a null value?

i've attaches a sample workflow?

[danilang]

Hi @Hamder83 

I'm not sure why, but it does.  If this is an issue you can always change it back in a formula tool with something like 

If isnull([Produkt Number]) then
   ""
Else
   [Produkt Number]
Endif

Dan