Notice: This page requires JavaScript to function properly.
Please enable JavaScript in your browser settings or update your browser.
Impara Trimming Whitespaces | Advanced Formatting of Cells
Google Spreadsheets Tutorial

bookTrimming Whitespaces

Trimming whitespaces is especially useful when working with email addresses. For example, if a cell contains " john.doe@example.com ", after applying Trim Whitespace, it will become "john.doe@example.com". This prevents potential errors when sending emails or importing data into other systems.

  1. Select the cells or range of cells where you need to remove extra spaces;
  2. Go to the Data menu → Data cleanupTrim Whitespace;
  3. Google Sheets will automatically remove all spaces at the beginning and end of the text in selected cells, leaving only single spaces between words.
question mark

What happens when you apply the Trim Whitespace function in Google Sheets?

Select the correct answer

Tutto è chiaro?

Come possiamo migliorarlo?

Grazie per i tuoi commenti!

Sezione 3. Capitolo 2

Chieda ad AI

expand

Chieda ad AI

ChatGPT

Chieda pure quello che desidera o provi una delle domande suggerite per iniziare la nostra conversazione

Awesome!

Completion rate improved to 1.45

bookTrimming Whitespaces

Scorri per mostrare il menu

Trimming whitespaces is especially useful when working with email addresses. For example, if a cell contains " john.doe@example.com ", after applying Trim Whitespace, it will become "john.doe@example.com". This prevents potential errors when sending emails or importing data into other systems.

  1. Select the cells or range of cells where you need to remove extra spaces;
  2. Go to the Data menu → Data cleanupTrim Whitespace;
  3. Google Sheets will automatically remove all spaces at the beginning and end of the text in selected cells, leaving only single spaces between words.
question mark

What happens when you apply the Trim Whitespace function in Google Sheets?

Select the correct answer

Tutto è chiaro?

Come possiamo migliorarlo?

Grazie per i tuoi commenti!

Sezione 3. Capitolo 2
some-alt