Need help with two functions please. Mainly just need help knowing what to type in cell F2 and Cell G2 for each function

In cell F2, use the appropriate function to display the street address from C2 in proper case. Copy the function down through cell F11.

The data in the cell range D2:D11 contains the customers home city and state. The last two characters in each cell contain the state abbreviation. In cell G2, use the appropriate functions to display the only city from D2. Be certain to remove extra spaces from the city name. Copy the function down through cell G11.

SUM - X Fi =PROPER E G H State F Street Address =PROPER PROPER(text) City B D 1 CustId Name Address City&State FullName 1 Gordon, Emily 5590 JUMAR Lake Havasu City CO Gordon, Emily 2 IBurns, Christopher 6940 COOK INLET Sahuarita ND Burns, Christopher 3 Watkins, Emma 9314 NW LOOP Tempe PA Watkins, Emma 4 Ford, Richard 5626 CINDYLEE Aguila IL Ford, Richard 5 [Duncan, Noel 3870 MADELYNNE Rio Rico NJ Duncan, Noel 6 [Fowler, Steven 8624 TOPAZ Salome VT Fowler, Steven 7 I Romero, Anthony 2993 DEBBIE Wenden IA Romero, Anthony 8 IMoody, Michael 7259 REED Marana VA Moody, Michael 9 IMartinez, Ella 3865 NORTH POINT Thatcher AZ Martinez, Ella 11 10 [Conner, Christopher 5828 ONDOLA Cottonwood HI Conner, Christopher