Using the LEFT and SEARCH functions to extract characters before a suffix in Google Sheets- A diagram and detailed formula breakdown

My name is Corey, I have been building spreadsheets for companies for over 7 years, I was a data specialist at an online school for 5 years, and I created this website to help people learn how to use spreadsheets.