ULEN function

Description

Length of string function. ULEN(str) returns the number of characters in the string str.

Example

ULEN(A20) returns 1 if cell A20 contains the string "𠜎".

Calculator

ULEN()

Unicode and UTF-16 encoding

MedCalc stores strings using UTF-16 character encoding. The ULEN function returns the actual number of characters in the string. This number can be different than the number of UTF-16 code units (16-bit units) used to store the string, notably when the string contains characters in the Unicode range U+10000 to U+10FFFF.

The number of UTF-16 code units is returned by the LEN function.

For example, for the Unicode character U+2070E (𠜎), ULEN("𠜎") returns 1 and LEN("𠜎") returns 2.

Use the LEN function when you need the length of a string in other string functions such as the LEFT(str,n), MID(str,pos,n), or RIGHT(str,n) functions.

Related functions

LEN function

List of String functions

External links

This site uses cookies to store information on your computer. More info...