## How to use the Excel T function

The Excel T function returns text when given a text value and an empty string (“”) for numbers, dates, and the logical values TRUE and …

## How to use the Excel VALUE function

Value function in Excel gives the value of a text which represents a number for example if we have a text as \$10 this is …

## How to use the Excel UPPER function

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

## How to use the Excel TRIM function

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

## How to use the Excel SUBSTITUTE function

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

## How to use the Excel SEARCH function

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

## How to use the Excel RIGHT function

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

## How to use the Excel REPT function

The REPT Function is categorized under Excel Logical functions. The function will repeat characters a given number of times. In financial analysis, we can use …

## How to use the Excel REPLACE function

The Excel REPLACE function replaces characters specified by location in a given text string with another text string. For example =REPLACE(“XYZ123″,4,3,”456”) returns “XYZ456”. Syntax: =REPLACE(old_text, …

## How to use the Excel PROPER function

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