Counting characters

One of the difficulties of dealing with text data is that it can often have an unpredictable length. To pinpoint and extract specific characters from a string of text, you first need to understand the concept of indexes. Indexes are unique positions assigned to every character in every string in a spreadsheet that you can use to perform more advanced text manipulations.

In this exercise, you'll use built-in Google Sheets functions to investigate the indexes of text-containing columns in the films table.