Extract from varied texts

In F3 try:

Formula:

=IF(A3="","",SUBSTITUTE(TRIM(MID(SUBSTITUTE(A3, " ",REPT(" ",99)),MAX(1,FIND("-",SUBSTITUTE(A3, " ",REPT(" ",99)))-50),99)),"""",""))

EDIT: It would likely help if you understood how the formulas worked. Here is a good explanation https://exceljet.net/formula/extract...-specific-text

be aware this formula assumes there isnt another "-" (without quotes) in the string, if there is it will not work.