• You are entering product ID codes in the cell range A1: A15. Product ID codes must always end with the characters xyz. Use data validation to ensure that each product ID code entered ends with xyz. Use the Custom setting and the RIGHT function.

 

A D F G H K L 1 2. 4 WALMART price 5 gumballs 6 musketeers 7 hershey 8 menthos price CVS price Target gumballs price 0.52 hershey Walgreens price Osco 0.6 0.92 Baby Ruth 0.97 dove bar 0.61 0.63 musketeers 0.67 lifesavers 0.58 mentos 0.78 Reece's 0.94 Baby Ruth lifesavers 0.74 gumballs 0.7 menthos 0.6 1 hershey 0.52 dove bar 0.74 0.79 0.84 menthos 0.75 Reece's 0.78 10 11 12