can you please give me formule to use for question in imgae formule should be in excel and please with good explaintion Second Half $($Use the data given in the file for the below questions$)$

For the variable $($LENDER$\_$LOAN$\_$ID$)$ try and split the columns by using the common delimiter present in this variable

For the variable $($PROP$\_$STATE$)$ try to fill in the state abbreviations to their full form by using a formula

Sort the variable LENDER$\_$NAME and get the top $5$ entries for the first alphabet and the last alphabet

Using formula find the answer for the below solution for the two variables $\{$ NEW$\_$CONSTRUCTION$\_$INDICATOR, CONDOMINIUM$\_$INDICATOR$\}$ Insert your answers below on the empty table