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
本练习是课程的一部分
Google Sheets 数据分析
练习说明
- 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.
