I have cell A1 = `1,0,0,1` cell B1=`,1,,-1` I need a formula that would be the equivalent of `=update(A1,B1)`. The numbers between the commas can be any number. I need B1 to replace data in A1 where there is a number. Cell C1 output: `1,1,0,-1` Note: A1 and B1 will always be in that format, 4 numbers separated by commas. more examples: A1 = `1,0,0,1` cell B1=`,1,,-1` --> `1,1,0,-1` A1 = `10,0,0,1` cell B1=`,1,,-1` --> `10,1,0,-1` A1 = `10,0,0,01` cell B1=`,1,,-1` --> `10,1,0,-1` A1 = `10,0,-1,0` cell B1=`,1,,-1` --> `10,1,-1,-1` A1 = `10,1,0,1` cell B1=`,0,,-1` --> `10,0,0,-1` A1 = `10,0,0,01` cell B1=`-1,1,,` --> `-1,1,0,01` General: A1 = `a,b,c,d` B1 = `e,f,g,h` --> make C1 by replacing `a` with `e`, `b` with `f`... etc, if `e,f,g,h` are not blanks.