Next time (if there is a next time), it might be simpler to use Google Forms rather than having folks email, and then having to copy/paste things to a spreadsheet. Google Forms is fast and simple to set up, and automatically puts everything into a spreadsheet for you. (No, I'm not affiliated with Google)
https://www.google.com/forms/about/