If formula results in “”, then that cell will not be empty.
When copy and paste as values, it will not be empty either.
When we use VBA (Macro command)
Range.value = Range.value
For that “” cell, it will make destination cell as empty.
Sorting table will consider cells with “” as 0, while empty cells are empty and will not be sorted results in order is different