In my Row 2 I have values that need to be manipulated to match criteria's in my workbook. In row 2 I have a list of names that need to change. For example in Row 2 I have a value of Stephanie but that cell needs to have a value of Steph. I only need this to change the values in row 2.