ASSIGNMENT INFORMATION Points Possible 50 Due Date Friday, October 22, 2021 3:00 PM Download the attached spreadsheet called "Text Function starting sheet.xlsx". Using Left, Mid, and Right you will then separate the three data items into three separate columns, C, D, and E. Using Excel functions, you will format columns C and E as proper nouns using Proper. You will make the format of the values in column D uppercase using Upper. You will then combine the three data items into a new single column (concatenate) with the values separated by spaces. This new column will combine the data from the columns in the following order: column E, C, and D. As an example, alabama (al), Montgomery becomes Montgomery Alabama (AL) When finished, make sure to click Submit. Optionally, click Save as Draft to save changes and continue working later, or click Cancel to quit without savir Choice Hotels.com alabama (al), montgomery alaska (ak).juneau arizona (az).phoenix arkansas (ar), little rock California (ca), sacramento colorado (co), denver connecticut (ct), hartford delaware (de). dover florida (fl). tallahassee georgia (ga). atlanta hawali (hi), honolulu idaho id). boise Illinois (l), springfield indiana (in), Indianapolis lowa (ia), des moines kansas (ks), topeka Kentucky (ky). frankfort louisiana (la), baton rouge maine (me). augusta maryland (md), annapolis massachusetts (ma), boston michigan (mi), lansing minnesota (mn). st. paul mississippi (ms), jackson missouri (mo), jefferson city montana (mt), helena nebraska (ne). lincoln nevada (nv). carson city new hampshire (nh), concord on excel new jersey (na), trenton new mexico (nm), santa fe new york (ny), albany north Carolina (ne), raleigh north dakota (nd), bismarck ohio (oh). columbus oklahoma (ok), oklahoma City Oregon (or), salem pennsylvania (pa), harrisburg rhode island (ri). providence south carolina (sc), columbia south dakota (sd), pierre tennessee (tn), nashville texas (tx). austin utah (ut), salt lake city vermont (vt), montpelier virginia (va), richmond washington (wa), olympia