Good Morning Everyone. It has been awhile since I have had to use an excel forum for questions. Thank you inadvance for the help of the community.
I am tasked with the following challenge. Column A is my original data. I need to output Column B and Column C with Formulas based on the following rules.

Rules:
If there is a comma split data before the comma in to Column A and the data after the comma into column B
The data in Column A (on both sides of the comma) can be an interger or a decimal
The data in Column A may not have a comma

If there is no comma enter the number value in Column A and Enter "0" Zero in Column B


1.PNG

I have the following data in column A (I have decimals sometimes, comma sometimes and no commas and no decimals sometimes)

50,35
50,35
50,35
40
52.5
50.6
50
50,40
50,60
50,60.5



I need the output in Column B to be as follows

50
50
50
40
52.5
50.6
50
50
50
50


I need the output in Column C to be as follows
35
35
35
0
0
0
0
40
60
60.5


I am truly stumped on this one. Any help would be greatly appreciated.