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.
In cell B1 ... =IF(C1=A1,"",LEFT(A1,3))
In cell C1 ... =TRIM(IF(LEFT(UPPER(A1),4) = "THE ",MID(A1,4,1000),A1))
Just move your references as need be.