NEED HELP WITH COMMAS, SPACES AND DELIMITERS IN A FORMULA

Hello!  I need help understanding and fixing the formula for the attached examples.  In the first example, the data in the first column is separated by a comma and a space.  In the second example, th...