The UPPER function is an Excel Text function, that will convert text to all capital letters (UPPERCASE). Thus, the function …

# Category: Excel functions

Lists all Excel functions by their category, such as Logical functions or Text functions.

Trim function in excel as the name suggests itself it trims some part of any string, why string because it …

Substitute function in excel is a very useful function which is used to replace or substitute a given text with …

The SEARCH function is a built-in function in Excel that is categorized as a String/Text Function. It can be used …

The RIGHT function is a built-in function in Excel that is categorized as a String/Text Function. It can be used …

The REPT Function is categorized under Excel Logical functions. The function will repeat characters a given number of times. In …

The Excel REPLACE function replaces characters specified by location in a given text string with another text string. For example …

Proper Excel function is used to make the given input in proper case, proper case means in a word the …

Mid function in excel is a type of text function which is used to find out strings and return them …

The LOWER function is categorized under Excel TEXT functions. The function will return the lowercase version of the text string …