LEN function

Applies To

SharePoint Server Subscription Edition SharePoint Server 2019 SharePoint Server 2016 SharePoint Server 2013 SharePoint Server 2013 Enterprise SharePoint v službe Microsoft 365 SharePoint Foundation 2010 SharePoint Server 2010 SharePoint v službe Microsoft 365 Small Business Windows SharePoint Services 3.0

LEN returns the number of characters in a text string.

Syntax

LEN(text)

Text is the text whose length you want to find. Spaces count as characters.

Examples

Col1	Formula	Description (Result)
Phoenix, AZ	=LEN([Col1])	Length of the string (11)
	=LEN([Col1])	Length of the string (0)
A One	=LEN([Col1])	Length of the string, which includes 5 spaces (9)