For the data below, all Customers have their Customer Type embedded within the Customer code. Use an Excel formula as you learnt in your Data Cleaning Excel courses to extract the Customer Type for each Customer. 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.

$10$

$11$

$12$

$13$

Customer Code

Type of Customer

RET$23$BOS$45$E$1$

$23$

RET$69$BOS$99$E$2$

$14$

EXT$84$NYC$66$E$1$

$15$

RET$78$BOS$64$P$1$

$16$

RET$24$SEA$14$P$2$