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!