LENGTH

Syntax:

LENGTH(text)

Returns the number of characters in the text string.

Examples:

LENGTH("cat")

returns 3.

IF(LENGTH("Manx cat") < LENGTH("Persian cat"), "Miaow", "")

should display the text string Miaow in the cell.