Poradnik Excela

How to remove extra spaces in Excel

Extra spaces in your cells can cause errors in formulas and look unprofessional. The TRIM function is the fastest way to clean your data.

Krok po kroku

1
Select an empty cell
Click on the cell next to the data you want to clean.
2
Enter the TRIM formula
Type =TRIM(A1) (replacing A1 with your target cell) and press Enter.
3
Copy the formula down
Double-click the fill handle at the bottom-right corner of the cell to apply it to the rest of the column.
4
Replace original data
Copy the new cells, right-click the original data, and select 'Paste Values' to finalize.

=TRIM(text)

TRIM leaves a single space between words, which is perfect for standardizing text formatting.

Does TRIM remove non-breaking spaces?

No, TRIM only removes standard ASCII space characters. For non-breaking spaces, use the SUBSTITUTE function.