Substituting characters
In this exercise, you'll be using your text manipulation skills to create standardized URLs for each film in the table.
These URLs must have three parts: www., the Film URL Slug, and -film.com.
For example, the URL forDoctor Strange would be:
www.doctor-strange-film.com
This exercise is part of the course
Data Analysis in Google Sheets
Exercise instructions
- In
A14:A23, remove any colons from the film titles by replacing them with an empty string. - In
C14:C23, create theFilm URL Slugby replacing the spaces inA14:A23with dashes (-), and making all text lowercase. - In
E14:E23, create theFilm Websiteby addingwww.to the beginning ofFilm URL Slugand-film.comto the end.
Hands-on interactive exercise
Turn theory into action with one of our interactive exercises
Start Exercise