Hope you are looking for solution in Alteryx, if yes, as other suggested use text to column tool... If you are looking for solution in excel , I will tell you are asking question on the wrong platform and if you still need solution in excel send a PM , I can help...