syntaxhelp.com Your online cheat sheet!

Calculating Lenth of a cell

=len(A2)
=len("Hima Bindu Vejella")

Output: Gets length of the cell A2 , Gets Output as 18

Calculating Left of a cell

=left(A2,4)
=left("HimaBindu Vejella", 4)

Output: Gets first four characters left of the cell A2 , Gets Output as Hima

Changing all the letters to lower case of a cell

=lower(A2)
=lower("HimaBinduVEJELLA")

Output: Gets all the letters in A2 as lower case, Gets Output as himabinduvejella

Changing all the letters to upper case of a cell

=upper(A2)
=upper("HimaVEJELLA")

Output: Gets all the letters in A2 as lower case, Gets Output as HIMAVEJELLA