And how do you want to split the data ? Pse post an example of the outcome needed

To clean your data you can use following formula in col b =TRIM(CLEAN(SUBSTITUTE(A2,CHAR(160)," "))) and drag down as needed