Creating a Dynamic Range for a Pivot Table Using the Offset

Creating a Dynamic Range for a Pivot Table Using the Offset

                               

REPT FUNCTION IN EXCEL

REPT()


REPT("this text",number of times)


=REPT(K,5) = KKKKK

=REPT(LOVE,3)= LOVELOVELOVE

UPPER FUNCTION IN EXCEL

UPPER(this text)

Example:-

=UPPER(kishan kumar)   = KISHAN KUMAR

=UPPER(Kishan Kumar)   = KISHAN KUMAR

LOWER FUNCTION IN EXCEL

LOWER(this text)

Example:-

=LOWER(Kishan Kumar)   = kishan kumar

=LOWER(KISHAN KUMAR)   = kishan kumar

PROPER FUNCTION IN EXCEL

PROPER(this text)

Example:-

=PROPER(kishan kumar)   = Kishan Kumar

=PROPER(KISHAN KUMAR)   = Kishan Kumar