No fancy story for this one. You are being asked to use text$-$based functions to manipulate string $($text$)$ data.

Complete the following:

$1.$ Open the Module $4-$ Words.xlsx workbook and save the file as Mod$4$Words$($your last name$).$xlsx$.$

$2.$ On the Concatenate sheet in Column D$,$ use a CONCATENATE formula to combine the names in columns A$,$ B$,$ and C as Last, First MI$.$ Ex: Stoney Brooks L will become Brooks, Stoney L

$3.$ On the Concatenate sheet in Column E$,$ use a CONCAT formula to combine the names in columns A$,$ B$,$ and C as Last, First MI$.$ Ex: Stoney Brooks L will become Brooks, Stoney L

$4.$ On the Concatenate sheet in Column F$,$ use the ampersand $($&$)$ symbol $($no formulas$)$ to combine the names in columns A$,$ B$,$ and C as Last, First MI$.$ Ex: Stoney Brooks L will become Brooks, Stoney L

$5.$ On the TextJoin sheet, for rows $2-10$ in Column F$,$ use a TEXTJOIN formula to combine the data in columns A:D$.$ Include a dash in between each cell$$s values

$6.$ On the TextJoin sheet, for rows $13-30$ in Column F$,$ use a TEXTJOIN formula to combine the data in columns B:D$.$ Include a space in between each cell$$s values and ignore the blank cells

$7.$ On the ReplaceSubstitute sheet, in column B$,$ complete the following:

a$.$ Rows $2-5$: Use the Replace function to replace the $5$th character with $$X$$

b$.$ Rows $8-11$: Use the Replace function to replace the $8$th character with $$USA$$

c$.$ Rows $14-17$: Use the Substitute function to remove the $2$nd dash

d$.$ Rows $20-23$: Use the Substitute function to remove only the $1$st dash

e$.$ Rows $26-29$: Use the Substitute function to replace the $2$nd dash with $$XXX$$

f$.$ Rows $32-55$: Use the Substitute function to replace all dashes with an underscore

$8.$ On the TextLenRept sheet, in Column C$,$ use a TEXT formula on the data in column A to make it look like the $$desired$$ data presented in column B$.$

$9.$ On the TextLenRept sheet, in Column E$,$ use a LEN formula to calculate the length of the text in each cell in column D$.$

$10.$ On the TextLenRept sheet in Column G$,$ use a nested formula $($meaning a function inside another function$)$ on the data in column D to make it look like the $$desired$$ data in column F$.$

$11.$ Save and close the Excel workbook.