COMPUTER EDUCATION

Today we discuss in this post Excel Text Category Functions like- Upper, Lower, Proper, Concatenate etc. so please read this post carefully for understanding text category important functions. 

Text Category Functions 

UPPER 

This function converts all selected text to uppercase.

Syntax

UPPER(text) 

Example - In this sheet written ramesh small letter to convert upper letter RAMESH = upper(A2) press enter result display RAMESH. 

 Excel Static Formulas, Average, Averageif, Averageifs

LOWER 

This function converts all selected text to lowercase.

Syntax

LOWER(text) 

Example - In this sheet written RAMESH Capital letter to convert small letter ramesh = LOWER(A2) press enter result display ramesh.

PROPER  

This function capitalizes the first letter in each word of a selected text value.

Syntax

PROPER(text)