A friend needed a quick hand the other day, to get just the last word from a cell.  He was splitting names into First / Last name, but didn’t want to use Text to Columns because the people on his list had anywhere between zero and three middle names. More →