You have just received sales data to analyze (Column A). Unfortunately, the sales records are formatted differently depending of the type of product. Records for A products are formatted ProductID:SalesDate-SalespersonID*Qty. Records for B products are formatted ProductID-SalespersonID:SalesDate*Qty. Records for C products are formatted ProductID*Qty-SalespersonID:SalesDate. 1. Use a single formula to populate C2:C35 with the quantity. Make sure to treat the quantity as a number