2. Len()

In data analysis, LEN is used to show the number of characters in each cell. It’s frequently utilised when working with text that has a character limit or when attempting to distinguish between product numbers.

SYNTAX = LEN (text)