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.
