$3.$ In the imported table, change some data to reflect updates in the company:

a$.$ Delete the row for Employee $520$ because Chad Johnson is no longer with Ballantyne Investments.

b$.$ Find the text "Financial advisor" and replace it with Investments to use a position name the company recently updated.

$4.$ Elena wants to list the team information in the range A$5$:E$10.$ The webpage table separated the first and last names, but Elena wants to list the full name on the Asset Management worksheet.

List the first and last names of each team member in a single cell as follows:

a$.$ In cell A$5,$ enter a formula using the CONCAT function that displays the first name shown in cell H$13$ followed by a space $("")$ and then the last name shown in cell I$13.$

b$.$ Fill the range A$6$:A$10$ with the formula in cell A$5$ to list the full names of the remaining team members.