how do i #9 and #10

viruses. Unless you need to edit, it's safer to stay in Protected View. Enable Editing In cell D3, use the RIGHT, LEN, and FIND functions to extract the first name from column C. Use the PROPER function to ensure that all first names are in the appropriate case. Resize the column as needed to fit the contents. In cell E3, use the LEFT and FIND function to extract the last name from column C Use the PROPER function to ensure that all last names are in the appropriate case. Resize the column as needed to fit the contents. In cell F3, use the LEFT and FIND function to extract the street address from column B. Use the PROPER function to ensure that all street names are in the appropriate case. Resize the column as needed to fit the contents. In cell G3, use the MID, LEN, and FIND functions to extract the city name from the address in column B Resize the column as needed to fit the contents. In cell H3, use the RIGHT function to extract the state from the address in column B Resize The column as needed to fit the contents In cell 13, use concatenation to put the customer first name and last name together with a space in between Resize the column as needed to fill the contents. Save the workbook. Close the workbook Exit Excel Submit the workbook as directed 8 9 10 11 Total Points peralta 605ch09.grader_hl_start(version 1) - AutoRecovered - Excel Autoleve Review View Formus Help Data Power Pivot Home Data Mining Insert Analytics Dar Page Layout 17 G 1 Joe's Sports Equipment Supply Chan - Name Lant Name Street Adress State - Full name Hale, Jeffery 310 ATKINS R, Milan Jeffery Hate Milan 1080 Atkins Rd 3362 ANNETTES, La Boya NM Mendoza, Jessica Jessica Mendona 3362 Annette St La Joya 5 2355 HEISER Tone NM Swanson, Madison Madison Swanson 2358 Heister itd Tome 615 HARONIK Blvd. Pague M reed, Clivia Olivia Reed Sa Baronik Blvd Paquete CeNM Fields josh Joseph Fields 1667 77Th 50 Cedar Crest 1707 TALON Santa TNM Brewer, ETHAN Ethan rower 3747 Talon Rd Santa Fe SISMOEN Sandel Rod, William William Rodrigo 5035 Midden Ave San Fidel 1922 UAE HOODT, Edwood NM REMING, Emily Emily Fleming 2 Lake Hood Tredwood M22 GETAFON Ronald art 2233 Bridget Ave Santa Fe STS Bom but tela sabella 1721 Settlers Blvd Boque D O SS G H