I currently have a course name and number in a cell or column, for example: 2019FA Microbiology (BIO-214-S104A). I'm currently using a left function to extract just the BIO-214 in another column because that's all I need for the outcome, and a mid function to extract the data inside the parenthesis to limit it down to BIO-214-S104A in a separate column. Can I combine the functions so that I don't need two different columns and functions to reach the desired result?
Functions used:
=MID(txt,SEARCH("(",txt)+1,SEARCH(")",txt)-SEARCH("(",txt)-1) and =LEFT(txt,7)