Again with Moviedata.xlsx, for each movie, extract the number of copies purchased from this data. You probably want to use the SUBSTITUTE function. The syntax of the SUBSTITUTE function is SUBSTITUTE(text,old_text,new_text,instance_number). If instance_number is omitted, every occurrence of old_text in text is replaced by new_text. If instance_ number is given, only that occurrence of old_text is replaced by new_text. For example, SUBSTITUTE(A4,1,2) would replace each 1 in cell A4 with a 2, but SUBSTITUTE(A4,1,2,3) would replace only the third occurrence of a 1 in cell A4 with a 2.