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

Split data into columns?

Hi all! I’m not a very regular Excel user, so hoping y’all can help me resolve this quicker than I would on my own 😅

I’m currently managing a form that has users select multiple volunteer shifts they’d like to sign up for. Each option is formatted as: Monday, May 21: 9:00 AM to 3:00 PM. Because they are listed in one question on the form, each shift selected is exported into one cell separated with quotations and a comma (like this: “Monday, May 21: 9:00 AM to 3:00 PM”, “Tuesday, May 22: 2:00 PM to 8:30 PM”, “etc”). The team is looking for a format that is simpler to read at a glance, but the multiple commas, semicolons, and spaces has me stumped.

Is there a different method of separating these instances into multiple cells I should be trying?? We work primarily with SharePoint versions, so a solution available from “Edit in Browser” is ideal.

TIA!

submitted by /u/ForsakenAd7981
[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
#natural language processing for spreadsheets
#Excel compatibility
#financial modeling with spreadsheets
#Excel alternatives
#rows.com
#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
#Excel
#SharePoint
#volunteer shifts
#multiple cells