Excel TRIM Function: How to Use It, with Examples
Turkish: KIRP

Removes leading and trailing spaces and reduces multiple spaces between words to one. Very useful for cleaning data pasted from other programs.

TRIM syntax

=TRIM(text)

In Turkish Excel: =KIRP(metin)

ArgumentDescription
textThe text to clean.

TRIM examples

Sample table:

ABC
1Full nameEmailCode
2ayşe yılmazayse@ornek.comTR-2026-001
3 Mehmet Demir mehmet@ornek.comTR-2026-042
=TRIM(A3)
Result: Mehmet Demir

Cleans up the extra spaces.

Results were calculated in real Excel.

Tips for TRIM

  • It does not remove non-breaking spaces from the web (CHAR(160)); use SUBSTITUTE for those.

Related functions

More formula guides

More tools

About TRIM Function

Removes leading and trailing spaces and reduces multiple spaces between words to one. Very useful for cleaning data pasted from other programs.

Turkish function names were taken directly from Turkish Excel, and the example results on formula pages were calculated in real Excel. Everything runs in your browser; your data is never uploaded.

How to use TRIM Function

  1. Type the formulaStart typing =TRIM( in a cell; Excel shows the arguments.
  2. Fill in the argumentsSeparate them with commas (semicolons in Turkish Excel).
  3. Press EnterCheck the result; you can also try it in the tester below.

Frequently asked questions

What is TRIM in Turkish Excel?

In Turkish Excel, TRIM is called KIRP. Turkish Excel also separates arguments with semicolons (;) instead of commas.

Which Excel versions have TRIM?

TRIM is available in all current Excel versions (2010 and later, Microsoft 365).