H Save your work + Prob 7 Product Key identifier for products) in column D has some problematic characters Tasks for this Question 4 (1) Adentify the character codes for the problematic characters that are a part of cell D25 see instructions just below) 5 In cell use a formula to count the # of characters of B17's contents(ProductKey cell D25's contents already copied to B11 5 Starting in cell 017, use a formula to place each individual character of 17 into its own single cell 7 Starting in DIS use a formula to display the character code of each individual character residing in the cell above (2) Use a formule in HOS to remove the problematic character found in 5 (ie, character code 160 from your part work), anywhere it might appear 9 Your formula should remove character code 160 even if the character should appear in a different position within 25 than currently found 10 copy your formula in H25 down the column 11 now your formulas infort. Do not paste special over any cells No need to make any changes to the range 025:074 Do not insert, delete, move, or "name" any rows, columns, or range. 13 Notes: You are not required to display Product Name for each sale Do all calculations in the cells designated for the problem (C17, 017:M18, & H25:H74). Do not add any 14 Product Data residing in columns M through Vis not needed Do not convert any range to a table 15 cell 0.25 of 16 contents characters 2 4 5 7 8 9 10 17 R93 R56 HVALUE VALUE! VALUE! VALUE! VALUEI AVALUED VALUE! VALUE! WALUEI AVALUE! 18 19 20 21 22 Sales Data Save your work! 23 6 new column Products for Customerke SalesOrder Productke tandard TotalPro SalesAm Product 24 Order Date Y Number Y ost ductCost ount ey 25 7/3/2016 16517 5043710 R93 R56 2171.294 2171.294 3578.27 7/3/2016 20042 SO43700 RSO R52 413.1463 413.1463 699.0982 7/3/2016 27616 S043707 R93 RAS 2171.294 2171.294 3578.27 7/3/2016 27621 5043706 R93 148 2171.294 2171.294 3578.27 29 7/4/2016 13513 5043712 R93 R4 2171.294 2171.2941 3578.27 30 7/4/2016 27606 S043711 R93 R56 2171.24 2171.294 3578.27 31 7/5/2016 13591 5043714 RS3 R44 2171.294 2171.294 3578.27 32 7/5/2016 16483 5043715 RS3 R56 2171.294 2171.294 357.27 33 7/5/2016 16529 5043716 R93 R44 2171 294 2171.294 3578.27 prob prob 4 probs prob 6 prob 7 prob 8 prob9 prob 10 prob 11 prob 12 data prob data prob data prob 9 data + Type here to search H Save your work + Prob 7 Product Key identifier for products) in column D has some problematic characters Tasks for this Question 4 (1) Adentify the character codes for the problematic characters that are a part of cell D25 see instructions just below) 5 In cell use a formula to count the # of characters of B17's contents(ProductKey cell D25's contents already copied to B11 5 Starting in cell 017, use a formula to place each individual character of 17 into its own single cell 7 Starting in DIS use a formula to display the character code of each individual character residing in the cell above (2) Use a formule in HOS to remove the problematic character found in 5 (ie, character code 160 from your part work), anywhere it might appear 9 Your formula should remove character code 160 even if the character should appear in a different position within 25 than currently found 10 copy your formula in H25 down the column 11 now your formulas infort. Do not paste special over any cells No need to make any changes to the range 025:074 Do not insert, delete, move, or "name" any rows, columns, or range. 13 Notes: You are not required to display Product Name for each sale Do all calculations in the cells designated for the problem (C17, 017:M18, & H25:H74). Do not add any 14 Product Data residing in columns M through Vis not needed Do not convert any range to a table 15 cell 0.25 of 16 contents characters 2 4 5 7 8 9 10 17 R93 R56 HVALUE VALUE! VALUE! VALUE! VALUEI AVALUED VALUE! VALUE! WALUEI AVALUE! 18 19 20 21 22 Sales Data Save your work! 23 6 new column Products for Customerke SalesOrder Productke tandard TotalPro SalesAm Product 24 Order Date Y Number Y ost ductCost ount ey 25 7/3/2016 16517 5043710 R93 R56 2171.294 2171.294 3578.27 7/3/2016 20042 SO43700 RSO R52 413.1463 413.1463 699.0982 7/3/2016 27616 S043707 R93 RAS 2171.294 2171.294 3578.27 7/3/2016 27621 5043706 R93 148 2171.294 2171.294 3578.27 29 7/4/2016 13513 5043712 R93 R4 2171.294 2171.2941 3578.27 30 7/4/2016 27606 S043711 R93 R56 2171.24 2171.294 3578.27 31 7/5/2016 13591 5043714 RS3 R44 2171.294 2171.294 3578.27 32 7/5/2016 16483 5043715 RS3 R56 2171.294 2171.294 357.27 33 7/5/2016 16529 5043716 R93 R44 2171 294 2171.294 3578.27 prob prob 4 probs prob 6 prob 7 prob 8 prob9 prob 10 prob 11 prob 12 data prob data prob data prob 9 data + Type here to search
