Notice: This page requires JavaScript to function properly.
Please enable JavaScript in your browser settings or update your browser.
Leer 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

Was alles duidelijk?

Hoe kunnen we het verbeteren?

Bedankt voor je feedback!

Sectie 3. Hoofdstuk 2

Vraag AI

expand

Vraag AI

ChatGPT

Vraag wat u wilt of probeer een van de voorgestelde vragen om onze chat te starten.

Awesome!

Completion rate improved to 1.45

bookTrimming Whitespaces

Veeg om het menu te tonen

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

Was alles duidelijk?

Hoe kunnen we het verbeteren?

Bedankt voor je feedback!

Sectie 3. Hoofdstuk 2
some-alt