$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 &$.$