Skip to main content
2 of 6
added 117 characters in body
jason
  • 1.1k
  • 5
  • 23
  • 41

updating a cell with fixed format without using code, formulas only

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.

output: 1,1,0,-1

Note: A1 and B1 will always be in that format, 4 numbers separated by commas.

jason
  • 1.1k
  • 5
  • 23
  • 41