The Incredibles (2018), by Brad Bird Avengers: Infinity War (2018), by Anthony Russo Deadpool 2 (2018), by

Fantastic news! We've Found the answer you've been seeking!

Question:

The Incredibles (2018), by Brad Bird

Avengers: Infinity War (2018), by Anthony Russo

Deadpool 2 (2018), by David Leitch

Solo: A Star Wars Story (2018), by Ron Howard

Black Panther (2018), by Ryan Coogler

Creed (2018), by Ryan Coogler

Bohemian Rhapsody (2018), by Bryan Singer

Ready Player One (2018), by Steven Spielberg

Mission: Impossible (2018), by Christopher McQuarrie

Hotel Transilvania 3 (2018), by Genndy Tartakovsky

Fantastic Beasts and Where to find them (2016), by David Yates

Sicario (2015), by Denis Villeneuve

Nice guys (2016), by Shane Black

Whiplash (2014), by Damien Chazelle

Skyfall (2012), by Sam Mendes

Twelve years a Slave (2013), by Steve McQueen

Dallas buyer's club (2013), by Jean-Marc Valle

TASK 1 (Text Length): Complete the "Text Length" (cell B2) for the Movie information in cell A2 using the LEN function. In other words, use the LEN function in cell B2 to measure the length of the text in cell A2. This function will count all characters, including spaces. Copy your formula down to complete the "Text Length" column;
TASK 2 (Title End): Calculate the ending position of the title, "Title End" (cell C2), for the movie in cell A2 using the SEARCH function. Copy your formula down to complete the column. Hint: Note that the title ends one character before the open parenthesis for the date. Use " (" in your search function as your "find_text" argument (notice the space before the parenthesis). This will locate the position of the space after the end of the title, so you must subtract 1 from the formula to find the last position in the title;
TASK 3 (DirectorStarts): Calculate the starting position for the director, "DirectorStarts" (cell D2), for the movie in cell A2 using the SEARCH function. The director's name starts after the text ", by ". Notice the spaces before and after the word "by". Use ", by " as the find_text argument for your function. Copy your formula down to complete the column. Hint: Since the director's name starts 5 characters after the comma, you will need to add "4" to your result. This will calculate the position right before the name of the director starts, making it easier to apply the RIGHT function in Task 6;
TASK 4 (Movie Title): Return the "Movie Title" (cell E2) for the movie in cell A2 using the LEFT function and the "Title End" position you found in step 2 (cell C2) as your "num_chars" argument. Copy your formula down to complete the "Movie Title" column;
TASK 5 (Year): Calculate the "Year" (cell F2) for the movie in cell A2 using the MID function and the "Title End" position you already calculated (cell C2) as the "start_num argument". Notice you will need to adjust this value because the year appears 3 characters after the position of "Title End". Since each year is four characters long, you can use 4 as the "num_chars" argument. Copy your formula down to complete the column;
TASK 6 (Director Name): Calculate the "Director Name" (cell G2) for the movie in cell A2 using the RIGHT function. The "num_chars" argument will be the difference between the "Text Length" you calculated in step 1 (cell B2) and the "DirectorStarts" position you calculated in step 3 (cell D2). Copy your formula down to complete the column;
TASK 7 (Title Upper): Calculate the "TITLE UPPER" (cell H2) for the movie using the UPPER function. Be sure to reference the movie title you calculated earlier (cell E2). Copy your formula down to complete the "TITLE UPPER" column;
TASK 8 (Citation): You will create the "Citation" in the correct format for each one of the movies. In cell I2, use the CONCAT function (or the CONCATENATE function in some versions of Excel) to combine the "Year", "TITLE UPPER", and "Director" fields according to the following format: Year. TITLE UPPER. Director. For example, in cell I2 you will find the text "2018. THE INCREDIBLES. Brad Bird". This is what citations should look like. Use the CONCAT function in cell I2 to replace the "text" with the function that builds the citation. Then, copy your formula down to complete the "Citation" column.