Add comma after specific text and location

[retrac]

Hi. I am trying to develop a formula to add a comma after every: "=1" or "<>1"

example: if(AND(KO9=1MA9=1XJ9=1RG10=1RW10=1ZR10=1LG11<>1ZR11=1),11,"")

note: the number of characters before the "=1", or "<>1" may change, ie KO9 to AFD13

 

[Rick Rothstein]

Hi. I am trying to develop a formula to add a comma after every: "=1" or "<>1"

example: if(AND(KO9=1MA9=1XJ9=1RG10=1RW10=1ZR10=1LG11<>1ZR11=1),11,"")

Do you really mean "after every"... even the one I highlighted in red?

 

[retrac]

Not before the closing parenthesis, you are correct. I was trying to limit the number questions and perhaps figure it out. Thanks!

 

[Rick Rothstein]

Not before the closing parenthesis, you are correct. I was trying to limit the number questions and perhaps figure it out. Thanks!

See if this formula does what you want...

=SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A1,"=1","=1,"),"<>1","<>1,"),",)",")")

 

[retrac]

That does it, and helps a-lot. Thank you!