A contact list exported from an old system: names with stray spaces and odd capitals, emails, phone numbers with dashes, and codes like CA-2026-0042 (state, year, number). Each task asks for a new column, from row 2 to row 6: write the formula in row 2 and fill it down.
Use whichever function fits. Most tasks have more than one right answer: LEFT with FIND, or TEXTBEFORE; MID, or TEXTAFTER.