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.
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.
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.
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.
The Microsoft Excel TRIM function returns a text value without leading, trailing and unnecessary spaces between words in a string. The TRIM function is a built-in function in Excel that is categorized as a String/Text Function.
In this video we described how to use TRIM function and its difference with CLEAN function.
LEN function is useful when you want to find the number of characters in the text. Gives the number of characters in given text string including spaces. This function is categorized as a String/Text Function.
In this video we described how to use LEN function in different situations.
The DOLLAR function, one of the TEXT functions, converts a number to text using currency format, with the decimals rounded to the number of places you specify. DOLLAR uses the $#,##0.00_);($#,##0.00) number format, although the currency symbol that is applied depends on your local language settings.
In this video we described how to use DOLLAR function in different situations.
LEFT, RIGHT and MID functions extract a substring from a string. We can specify how many characters to be extracted. This functions are categorized as a String/Text Function.
In this video we described how to use LEFT , RIGHT and MID functions in different situations.
The Microsoft Excel SEARCH and FIND functions returns the location of a substring in a string. The only difference between these two functions is that FIND is case-sensitive, but SEARCH is NOT. SEARCH and FIND functions are built-in functions in Excel that are categorized as String/Text Functions.
In this video we describe these functions in details and explain the difference between them with examples. For more videos like this, please subscribe us.
In this video we talk about what is Excel spread sheet is and the meaning of a work book, sheets and cells. We also talk why we can save data in cells and what is the complete address of a workbook, spreadsheet and cells. This concepts are critical for understanding Excel and working with it in proper manner.
