For the data below, all employees are listed by first name and their employee code. Use an Excel formula as you learnt in your Data Cleaning Excel courses to extract Employee Code for each employee.

You are required to use the Excel formulae for data cleanup as you saw in the Course. A sample is shown for the first customer on what should be shown as a result of the Excel formula that you use.

$7$

$8$

Ready

$*$ Accessibility: Good to go

$63,371$

JAN

$13$

$$

Conditional Formatting

Format as Table

Cell

Styles

$5$E Inse

Bs Del

$$

For

$5$ points

$9$

Name and Code

Employee Code

$10$

Sammy $98965$

$98965$

$11$

John $87572$

$12$

Harry $34692$

$13$

Samuel $67682$

$14$

Dolly $67876$