ComeçarComece gratuitamente

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

Análise de dados no Planilhas Google

Ver Curso

Instruções de 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

Comece o exercício