trailing spaces

[ABC_Anonymous]

Hello ,  I am trying to update sheets name from an excel file, but some of them have trailing spaces in it, i want to delete this spaces

thanks for your support

[binuacs]

@ABC_Anonymous use the Trim() function

eg: Trim([Field Name])

[chukleswk]

You can use the Data Cleansing tool and select "Leading and Trailing Whitespace" in the Remove Unwanted Characters section.

 

[ABC_Anonymous]

i want to Remove Leading and Trailing Whitespace in the sheet name and save it 

[RJ_1988]

Trim (Colname), Data Cleansing tool (Check Leading and Trailing Whitespaces), and in some cases use additionally a formula tool Replace(Colname,' ','')