ComeçarComece de graça

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

Este exercício faz parte do curso

Data Analysis in Google Sheets

Ver curso

Instruções do exercício

  • In A14:A23, remove any colons from the film titles by replacing them with an empty string.
  • In C14:C23, create the Film URL Slug by replacing the spaces in A14:A23 with dashes (-), and making all text lowercase.
  • In E14:E23, create the Film Website by adding www. to the beginning of Film URL Slug and -film.com to the end.

Exercício interativo prático

Transforme a teoria em ação com um de nossos exercícios interativos

Começar o exercício