1 min readfrom Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

All the data points/numbers are entered into 1 cell as text - how do I get excel to execute standard functions from this?

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.

submitted by /u/mr_nefarious_
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article

Tagged with

#rows.com