$1\mathrm{.}7$ Create a phrase with the text after the XX in the sentence $($cell $($D$2)).$

Use a RIGHT function and the values you found for the length and the XX$.$

Account for the $x$ characters in the function argument.

$1\mathrm{.}8$ Create a message to the HR Manager by using all the details about each employee and the phrases you created.

Use a CONCAT function.

The message should have appropriate spacing.

Copy and paste the function down to complete the column.