SUBSTITUTE replaces part of a text string, based on the characters you specify, with a different text string. This function is categorized as a *String/Text Function*. In this video we described how to use SUBSTITUTE function in different situations.

# Tag: cell formatting

## REPLACE function in Excel

REPLACE replaces part of a text string, based on the number of characters you specify, with a different text string. This function is categorized as a *String/Text Function*. In this video we described how to use REPLACE function in different situations.

## T Function in Excel

The Microsoft Excel T function returns the text referred to by a value. The T function is a built-in function in Excel that is categorized as a String/TextFunction. It can be used as a worksheet function in Excel

In this video we described how to use T function in different situations

## EXACT Function in Excel

The EXACT function compares two text strings and returns TRUE if they are exactly the same, FALSE otherwise. **EXACT** is case-sensitive but ignores formatting differences. Use EXACT to test text being entered into a document. In this video we described how to use EXACT function in different situations.

## TEXTJOIN function in Excel

The Excel TEXTJOIN function concatenates (joins) values with a given delimiter. Unlike the CONCAT function, TEXTJOIN allows you to supply a range of cells, and has a setting to ignore empty values.

In this video we described how to use TEXTJOIN function in different situations.

## REPT Function in Excel

The Microsoft Excel **REPT function** returns a repeated text value a specified number of times. This function is categorized as a *String/Text Function*.

In this video we described how to use REPT function in different situations.

## NUMBERVALUE function in Excel

The Microsoft Excel NUMBERVALUE function converts a text value to a number by specifying the decimal and group separators. The NUMBERVALUEfunction is a built-in function in Excel that is categorized as a String/Text Function. It can be used as a worksheet function (WS) in ExcelIn this video we described how to use NUMBERVALUE function in different situations.

## TEXT Function in Excel

The TEXT function lets you change the way a number appears by applying formatting to it with format codes. It’s useful in situations where you want to display numbers in a more readable format, or you want to combine numbers with text or symbols.. This function is categorized as a String/Text Function.

In this video we described how to use TEXT function in different situations.

## FIXED function in Excel

The Microsoft Excel FIXED function returns a text representation of a number rounded to a specified number of decimal places. This function is categorized as a *String/Text Function*. It can be used as a worksheet function (WS) in Excel. As a worksheet function, the FIXED function can be entered as part of a formula in a cell of a worksheet.

In this video we described how to use EXACT function in different situations.

## UPPER , LOWER , PROPER functions in Excel

The Microsoft Excel UPPER, LOWER and PROPER functions converts capital and lower-case letters to each other in the way we need. UPPER function capitalizes all the letters in a word and LOWER function do exactly opposite of UPPER and converts all the letters in a word to lower-case. The PROPER function capitalizes all the first letters in each word and converts rest of the letters to lower-case.

These functions is categorized as a String/Text Functions. they can be used as a worksheet function (WS) in Excel. As a worksheet function, these functions can be entered as part of a formula in a cell of a worksheet.

In this video we described how to use UPPER, LOWER and PROPER functions in different situations.