In cell D5 of the Billing_Hours_Data worksheet, use the PROPER, MID and FIND functions to extract the company name from column B. (For the first company, the company name is Burruss Broadcasting Services, Inc.) Copy the formula down the column. Resize the column as needed to fit the contents.

What formula would i need to put into excel to get the correct information in each cell because each cell has a different number of characters?

RIS 2004 LXIa TulCLIUIIS TUlleWULKASSIummer Pug 2020 DULCnellace Home Insert Draw Page Layout Formulas Data Review View Comments Share Z = = = Dev ako Wrap Text v General v 6 Pa Ev AZ O Insert v EX Delete v Format v Paste Calibri (Body) v 11 v A BI U vv av Av. A x fx Merge & Center v $ ~ % . O Ideas Sensitivity Conditional Format Formatting as Table Cell Styles X v Sort & Filter Filter Find & Select 05 2/2/2020-2/8/2020 Data imported on 2/10/20 Company Name Street Address City/Town State Senior_Hours 4.75 7.75 Service_Code 160 110 150 150 130 8.25 7.75 1 Client_Data B21773*burruss broadcasting services, inc.??4 commerce st/christiansburgVA 08567*cheatham organics company??2160 natures way/floydVA C69955*cochrane fitness company??1008 cascade In/vintonVA 08913564*cowgill electrical products, inc.??740 harvest In/radfordVA D41054*derring geological services, inc.??28 perry blvd/lynchburgVA E280578*engel foods company??342 falcon dr/blacksburgVA F12772*femoyer power tools company??154 stevens ct/pearisburgVA G632107*goodwin international, inc.??4200 university ave/roanokeVA H34105*hahn landscaping, inc.??902 campus dr/radfordVA H410524*hillcrest trading company??306 mercer ave/roanokeVA H56568*holden publishing company??405 maple ave/christiansburgVA L674883*latham industries, inc.??863 oak st/pembrokeVA 5 erce st/christiansburgVA 6 /floydVA 2 7 nton VA 8 est In/radfordVA 9 /lynchburgVA? 10 urgVA? 11 /pearisburgVA 12 ity ave/roanokeVA 13 DVA 2 14 roanokeVA 15 christiansburgVA 16 VAZ Company ID B21773 08567 C69955 C8913564 D41054 E280578 F12772 G632107 H34105 H410524 H56568 L674883 8.75 Associate_Hours 14 15 10.75 12.5 12.75 17.75 14.75 16 13 15.75 15.25 15 130 110 Manager_Hours Director_Hours 1.5 0.5 2.5 1 5 0.75 3.5 0.5 2.5 0.25 3.5 1.25 20.5 2 2.5 1 3.5 1.5 0.75 8.5 9.75 8 4.5 150 160 140 140 110 5.5 9 8.25 ILL . OHITH OI. AI - - - - . . . RIS 2004 LXIa TulCLIUIIS TUlleWULKASSIummer Pug 2020 DULCnellace Home Insert Draw Page Layout Formulas Data Review View Comments Share Z = = = Dev ako Wrap Text v General v 6 Pa Ev AZ O Insert v EX Delete v Format v Paste Calibri (Body) v 11 v A BI U vv av Av. A x fx Merge & Center v $ ~ % . O Ideas Sensitivity Conditional Format Formatting as Table Cell Styles X v Sort & Filter Filter Find & Select 05 2/2/2020-2/8/2020 Data imported on 2/10/20 Company Name Street Address City/Town State Senior_Hours 4.75 7.75 Service_Code 160 110 150 150 130 8.25 7.75 1 Client_Data B21773*burruss broadcasting services, inc.??4 commerce st/christiansburgVA 08567*cheatham organics company??2160 natures way/floydVA C69955*cochrane fitness company??1008 cascade In/vintonVA 08913564*cowgill electrical products, inc.??740 harvest In/radfordVA D41054*derring geological services, inc.??28 perry blvd/lynchburgVA E280578*engel foods company??342 falcon dr/blacksburgVA F12772*femoyer power tools company??154 stevens ct/pearisburgVA G632107*goodwin international, inc.??4200 university ave/roanokeVA H34105*hahn landscaping, inc.??902 campus dr/radfordVA H410524*hillcrest trading company??306 mercer ave/roanokeVA H56568*holden publishing company??405 maple ave/christiansburgVA L674883*latham industries, inc.??863 oak st/pembrokeVA 5 erce st/christiansburgVA 6 /floydVA 2 7 nton VA 8 est In/radfordVA 9 /lynchburgVA? 10 urgVA? 11 /pearisburgVA 12 ity ave/roanokeVA 13 DVA 2 14 roanokeVA 15 christiansburgVA 16 VAZ Company ID B21773 08567 C69955 C8913564 D41054 E280578 F12772 G632107 H34105 H410524 H56568 L674883 8.75 Associate_Hours 14 15 10.75 12.5 12.75 17.75 14.75 16 13 15.75 15.25 15 130 110 Manager_Hours Director_Hours 1.5 0.5 2.5 1 5 0.75 3.5 0.5 2.5 0.25 3.5 1.25 20.5 2 2.5 1 3.5 1.5 0.75 8.5 9.75 8 4.5 150 160 140 140 110 5.5 9 8.25 ILL . OHITH OI. AI