Separating By Comma Equation Doesn't Always Work

Hello! I am trying to create an automatic system for separating a set of names by comma. I realize that I can do text to columns, but I was requested to try and create an equation for this so that th...