The Church of Jesus Christ of Latter-day Saints

In case anyone is interested, there is an update to the spreadsheet that will automatically remove extra spaces between names. While this really shouldn't be a big deal, the way the background formulas and scripts work 2 extra spaces between a first and last name would often cause the pulpit sheet ...

I have a work-around to my problem (question about Hispanic ward members with multiple last names) but still would prefer a way to include all names before the comma as the last name. The work-around is to copy from online MLS into Excel. Then I run this Excel formula to remove spaces between names ...

Once more, again, an updated link for the template to make your own version - https://docs.google.com/spreadsheets/d/1I9DFq2CwPAUywfkCb8jrSOm1a8nsj5scm2NbVr0GEi0/edit#gid=54 This is brilliant, thanks! I'm not familiar with Google Apps Script and am not sure how to fix an issue with the speakers imp...