3 Using Text functions, in column B, create an inventory code from the products in column A that will look like in cell B8. 4 Also, output the last word at column C from column A. See example in row 6. 5 Do this with single formula applicable only by column. 6 7 8 9 10 11 12 13 NOTE: In each worksheet there are better solutions that was taught or not taught in Cou

Using Text functions, in column B, create an inventory code from the products in column A that will look like in cell B8. Also, output the last word at column C from column A. Sec example in row 6. Do this with single formula applicable only by column. NOTE: In each worksheet there are better solutions that was taught or not taught in Cour 3 Using Text functions, in column B, create an inventory code from the products in column A that will look like in cell B8. Also, output the last word at column C from column A. See example in row 6. Do this with single formula applicable only by column. NOTE: In each worksheet there are better solutions that was taught or not taught in Coursera