code class$=$"asciimath"$>1.$ Open the file and select the Developers tab. $2.$ Use the PROPER function to format the text from range B$2$:B$11.$ The formatted text should be placed into cells C$2$:C$11.3.$ Use the TRIM function in cells D$2$:D$11$ to remove the extra spaces from the names in range C$2$:C$11.4.$ Using text functions, you will convert the developers$$ names to the Last name, Initial. format using the following steps: $*$ Determine how many characters you will need to include in order to have the name as Last name, Initial. Hints: i$.$ In cells E$2$:E$11,$ use the FIND function to locate the number of characters of the last name followed by the space in the trimmed name. ii$.$ In cells F$2$:F$11,$ add $1$ to the number in cells E$2$:E$11$ to include the first initial. $*$ Using the LEFT function and the &$,$ copy the developers$$ names in the Last name, Initial. format to cells G$2$:G$11.$ Hint: To add the period after the first name initial, use &$.$