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
Latihan ini adalah bagian dari kursus
Data Analysis in Google Sheets
Petunjuk latihan
- 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.
Latihan interaktif praktis
Ubah teori menjadi tindakan dengan salah satu latihan interaktif kami.
Mulai berolahraga