Address MAIN STREET, LITTLETON 5TH AVENUE, MCKEESPORT FRONT STREET, WATERVILLE CLINTON AVENUE, ALBANY OAK STREET, PATCHOGUE CHESAPEAKE BOULVARD, ELKTON MCDOWELL STREET, WELCH Abbreviation of Road Name Road Name Short Address STREET ST AVENUE AVE No Formula No Formula MAIN ST, LITTLETON 5TH AVE, MCKEESPORT (1) Please write the formula (use MID and FIND functions) that returns road name in the address in cell B4. Copy the formula and paste it into cells B5:B7 (2) Please write the formula (use VLOOKUP and MATCH functions, and the table range F12:G15) that returns abbreviation of road name in the address in cell C4. Copy the formula and paste it into cells C5:C7 (3) Please write the formula (use SUBSTITUTE function) by using the formulas you obtained in columns B and C to get short address in cell D4. Copy the formula and paste it into cells D5:D8 Road Name Abbreviation of Road Name STREET ST AVENUE BOULVARD AVE BLVD In FIND function in Column B use only "," and "" In SUBSTITUTE function in Column D, use the formulas you obtained in column B and C, as old_text and new_text respectively