u/mr_nefarious_

Have been handed raw data in an excel file and all of the numbers are entered into a single cell as text data, such as in the following example.

I have over 250 rows of this. So far the only solution I have found is to manually re-enter all of the scores for each patient into individual cells for each score. Is there ANY way to automate the min, max, median, and mean for a data set like this? I have searched for almost 2 hours and have not found an answer. Really hoping that somebody here can please help me, as having to manually enter all of this data is going to take forever.