What is the purpose of the TRIM function in Excel?

Microsoft Excel Medium

Microsoft Excel — Medium

What is the purpose of the TRIM function in Excel?

Key points

  • The TRIM function targets spaces, not characters or numbers.
  • It standardizes spacing within text strings.
  • The function leaves single spaces intact between words.
  • It does not modify the original text's content, only its formatting.

Ready to go further?

Related questions