Nas T has to convert sport names to a 4-letter abbreviation. If the sport name has one word, then use the left four characters. But, if the sport name has two words, use the left 3 letters from the first word followed by the first letter from the second word. AND… Nas says we have to use the IF formula. My solution includes some LEFT, MID, IFERROR, FIND functions. Also in this episode: Flash Fill.