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.