MS Excel Must know Upper lower len Pivot function

MS Excel Most useful functions and tricks of MS Excel:

MS Excel Must know Upper lower len Pivot function

1) Use of Len:

it is used to determine and get the length of characters in a cell of MS Excel. The formula is very simple. Let us assume that we want to determine the length of characters in cell A1. In this case the formula will be:
=len(A1)

Illustration:

MS Excel cell length and len function-1

And the result of Len formula will be showing us the number of characters in a cell of MS Excel as depicted below:

MS Excel cell length and len function-2

MS Excel cell length and len function-2

2) How to convert text in MS excel cell from lowercase to upper case?

This is quite easy to do with “UPPER” function of MS excel which converts small text to upper case text. An example is shown below:
Illustration:

MS Excel Text Upper Case function-1

MS Excel Text Upper Case function-1


Let us say that we want to change the case of text in below table:

Formula for upper case conversion:

MS Excel  Convert text to upper case-2