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.

I just need to know what to type in for the functions, there is no other information other what is shown in the table

F G H I Street Adress City State Full Na C D E Joe's Sports Equipment Supply 2 Customer name Address Clean Name First Name Last Name 3 Hale, Jeffery 1880 ATKINS Rd, Milan NM Hale, Jeffery 4 Mendoza, Jessica 3362 ANNETTE St, La Joya NM Mendoza, Jessica 5 Swanson, Madison3 2358 HEISLER Rd, Tome NM Swanson, Madison 6 Ereed, Olivia 3 9635 BARONIK Blvd, Paguate NM reed, Olivia 7 Fields, joseph 1667 77TH St, Cedar Crest NM Fields, joseph 8 IBrewer, ETHAN 3747 TALON Rd, Santa Fe NM Brewer, ETHAN 9 Rodriguez, Williama a 6035 MIDDEN Ave, San Fidel NM Rodriguez, William 10 FLEMING, Emily: 8232 LAKE HOOD Trl, Edgewood NM FLEMING, Emily 11 Hart, Ronald 2 2293 BRIDGET Ave, Santa Fe NM Hart, Ronald 12 Elliott, Isabella 1731 SETTLERS Blvd, Bosque NM Elliott, Isabella