Syntax:
LENGTH( text )
Returns the number of characters in the text string.
Examples:
LENGTH("cat")
returns 3.
3
IF(LENGTH("Manx cat") < LENGTH("Persian cat"), "Miaow", "")
should display the text string Miaow in the cell.
Miaow