delete leading and trailing spaces in a row

Hello;
In a column in the data I get in Excel, I have a different number of spaces at the beginning and end of the data and I can’t filter the column for this reason. How do I solve the initial and trailing spaces in cells?

the number of initial and trailing blank characters in each row is different (I can’t filter)

I’m trying to select from there when I see the (Row filter) information in the column doesn’t work.

Hi,

you can use the String Manipulation’s strip(…) function:

Strips any whitespace characters from the beginning and end of given strings.

Best,
Philipp

5 Likes

Well
Is this formula-like solution applicable in excel?

=PROPER(Text)

You’ll need LowerCase and Capitalize functions used together.

4 Likes

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.