I made some minor mistake in collecting data and what happens now is that I have a beautiful excel file with a column reading something like this:

I need to remove the extra information, but I have not been able to find a way to do so. Clearly, It is not possible to use text to column, but I thought there must be a way to fix this. Any tip? (Please! It's 13,000 rows!)

Thanks!