Hello,
I am puzzled with this one.
I have sheet with numerous columns.
Col A - Col B - Col C - Col D - etc
SKU1 - 0 - 0 - 125
SKU2 - 12 - 0 - 14
SKU3 - 0 - 56 - 0
SKU4 - 0 - 0 - 1
I would like to replace all the 0 in a row, starting from the left UNTIL I encounter a value so the above would become (I entered "" where I would like to remove the 0)
Col A - Col B - Col C - Col D - etc
SKU1 - "" - "" - 125
SKU2 - 12 - 0 - 14
SKU3 - "" - 56 - 0
SKU4 - "" - "" - 1
Any idea on how to tackle this one? I am puzzled :/
Thanks in advance
Ludo
Bookmarks