Power Pivot - blanks in Text

[Bilingual]

Hi i have one more question, when i import Data i have a text column which i relate to another column in order to create a limit. Unfortunately the first column contains empty blanks like
"FLE12 " instead of "FLE12", i ususally remove them with REMOVE BLANKS in Excel, but can Powerpivot do the same or do i need to clean it before?

 

[MarcelBeug]

In Power Query: Transform tab - select your column(s) - Format - Trim.

By the way: where can I find REMOVE BLANKS in Excel?

 

[Bilingual]

In Power Query: Transform tab - select your column(s) - Format - Trim.

By the way: where can I find REMOVE BLANKS in Excel?

Sorry in my native languagte TRIM is called REMOVE BLANKS