How to use EXACT function in Microsoft Excel

Excel version in which EXACT function can work: EXACT function can work in all of the latest version of Microsoft office. About EXACT function in excel: It compares two cells in excel, result will be TRUE if values in both cells are exactly same. Result will be FALSE if values are not same. Syntax for EXACT Function: =EXACT(text1, text2) Parameters: text1 and text2 = Two cell values to compare. It is a case sensitive when comparing it with two strings.…

Continue Reading

Using VALUE Function in Excel

Excel Version in which VALUE functions can work: Excel VALUE function works in all Excel Versions. About Excel VALUE function: The Microsoft Excel VALUE formula converts a text value that represents a number to a number. It is a built in String or Text function in excel. It also can be used as a worksheet function. Syntax for VALUE: =VALUE(text) Parameters: text : The cell to convert to a number.If text is not a number, the VALUE formula will return #VALUE!. Using…

Continue Reading

How to use Excel Replace function

Version in which REPLACE function can work: Excel REPLACE function will work in Excel 2016 Excel 2013 Excel 2010 Excel 2007 Excel 2016 for Mac Excel for Mac 2011 Excel Online Excel for iPad Excel for iPhone Excel for Android tablets Excel Starter Excel Mobile Excel for Android phones. About REPLACE function: The Excel REPLACE function replaces the text based on the location which we provide in the formula. Syntax for excel REPLACE Function: =REPLACE(old_text,start_num,num_chars,new_text) Parameters: old_text: The text to…

Continue Reading

How to use Excel Text function

Excel version in which TEXT function can work: Excel TEXT function will work in Excel 2016 Excel 2013 Excel 2010 Excel 2007 Excel 2016 for Mac Excel for Mac 2011 Excel Online Excel for iPad Excel for iPhone Excel for Android tablets Excel Starter Excel Mobile Excel for Android phones. About TEXT function: The excel TEXT function converts the cell into a text format in a specified format. It is a built in worksheet function. You can use this function as…

Continue Reading

How to use Excel Left Right Function

Excel version in which LEFT and RIGHT function can work: Excel LEFT RIGHT function will work in Excel 2016 Excel 2013 Excel 2010 Excel 2007 Excel 2016 for Mac Excel for Mac 2011 Excel Online Excel for iPad Excel for iPhone Excel for Android tablets Excel Starter Excel Mobile Excel for Android phones. About excel LEFT and RIGHT function: LEFT and RIGHT function extracts a letter from a word starting from the left-most character or right most character respectively. LEFT and RIGHT is…

Continue Reading

How to use excel FIXED function

Excel version in which Fixed function can work: Excel Fixed function is a built-in function in Excel, This function will work in Excel 2016, Excel 2013, Excel 2011 for Mac, Excel 2010, Excel 2007, Excel 2003, Excel XP, Excel 2000, Excel Online Excel for iPad Excel for iPhone Excel for Android tablets Excel Mobile Excel for Android phones. About FIXED function in excel: In Excel, FIXED function rounds the number into a specified number of decimals with or without commas…

Continue Reading

Proper in excel: How to use PROPER worksheet function

Excel version in which Proper function can work: PROPER in excel functions will work in Excel 2016, Excel 2013, Excel 2011 for Mac, Excel 2010, Excel 2007, Excel 2003, Excel XP, Excel 2000, Excel Online Excel for iPad Excel for iPhone Excel for Android tablets Excel Mobile Excel for Android phones. About function Proper in excel: PROPER function in excel converts all texts to propercase. If the characters are other than letters , they are unaffected by using this function. Syntax…

Continue Reading

Excel Change case functions- UPPER & LOWER

Excel Version in which UPPER & LOWER functions can work: Excel Change case functions will work in Excel 2016, Excel 2013, Excel 2011 for Mac, Excel 2010, Excel 2007, Excel 2003, Excel XP, Excel 2000, Excel Online Excel for iPad Excel for iPhone Excel for Android tablets Excel Mobile Excel for Android phones. About Excel Change case functions- UPPER & LOWER: UPPER function in excel converts all texts to Uppercase. If the characters are other than letters , they are unaffected…

Continue Reading

MID function in excel worksheet

Excel Version in which MID function can work: MID function will work in Excel 2016, Excel 2013, and Excel 2011 for Mac, Excel 2010, Excel 2007, Excel 2003, Excel XP, and Excel 2000. About MID function: MID worksheet function extracts specified number of letters from a word. This is a built in function in excel that is categorized as text function. It can be used as a worksheet function and VBA function in macro code that is entered through the…

Continue Reading

Left, Right and Len functions in excel

If you want to split the information in a cell and get only few number of characters in a particular cell you can use the simple functions like LEFT or RIGHT.LEFT: syntax for LEFT function=LEFT(text, [num_chars])LEFT function will give the number of characters given in the formula from left of the referred cell. If the number of characters is not given, then it will take it as 1. For example, the information contains Employee Number and Employee name in same cell, then…

Continue Reading
Close Menu
×

Cart