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

#Excel alternatives for data analysis
#generative AI for data analysis
#big data management in spreadsheets
#conversational data analysis
#real-time data collaboration
#intelligent data visualization
#data visualization tools
#enterprise data management
#big data performance
#data analysis tools
#data cleaning solutions
#natural language processing for spreadsheets
#rows.com
#Excel compatibility
#Excel alternatives
#Excel
#data
#scores
#raw data
#text data