How to extract a special word from the beginning of values in excel?

There is a column in excel want to extract the word of the from the beginning of values. Just the word of the must extract.

enter image description here


In cell B1 ... =IF(C1=A1,"",LEFT(A1,3))

In cell C1 ... =TRIM(IF(LEFT(UPPER(A1),4) = "THE ",MID(A1,4,1000),A1))

IF

Just move your references as need be.