TRIMENDS 函數

支持

登入

Hello,

Select a different account.

You have multiple accounts

Choose the account you want to sign in with.

Applies To

SharePoint Server Subscription Edition SharePoint Server 2019 SharePoint Server 2016 SharePoint Server 2013 SharePoint Server 2013 Enterprise SharePoint in Microsoft 365 SharePoint Foundation 2010 SharePoint Server 2010 SharePoint in Microsoft 365 Small Business

拿掉前置和結尾空格，例如文字前後的空格和非裂斷空格。在您從另一個應用程式收到的文字字串上使用TRIMENDS，且字串前後可能具有額外間距。

附註: TRIMENDS 會保留文字字串內的間距。若要變更文字字串內的間距，請使用TRIM函數。如需詳細資訊，請參閱 TRIM 函數。