How to use Excel CONCAT Function

Introduction CONCAT in excel is a text/string function. This function is used to merge several text strings or ranges. This function was included in Excel 2016 and available in later versions, it replaced CONCATENATE function. This function does not include delimiter/Ignore Empty arguments. Syntax =CONCAT(Text1, Text2, ….) Arguments Text1: It is the text values which will be merged together, can be a string or an array of strings or a range of cells.Text2:  Additional text values to be joined, maximum…

Continue Reading

How to use Excel DBCS Function

Introduction DBCS function in excel is a text/string function. Its full form is (Double Byte Character Set). This function is used to convert single byte characters into double byte characters in a text string. This function is useful for multiple languages and unique characters. Half width characters are converted to full width characters. For example, =DBCS(“PRINCE) gives PRINCE as the result. Syntax =DBCS(Text) Arguments Text: It is the text or reference which contains the characters you wants to convert to…

Continue Reading

How to use Excel DOLLAR Function

Introduction DOLLAR in excel is a text/string function. This function converts a numeric value into text value using Currency Format and it also rounds off decimal places to the value specified. The currency character used is dependent on the local languages settings. Format which this function uses is$#,##0.00_);($#,##0.00). For example, 12 is converted to $12 by using the formula =DOLLAR(12) Syntax =DOLLAR(Number, Decimals) Arguments Number: It is the number or a reference to a cell which contains the number.Decimals: It…

Continue Reading

How to use Excel CLEAN Function

Introduction CLEAN in excel is a text/string function. This function cleans non printable elements and line breaks in a text. It can be used to omit non printable elements from text that has been imported from other software or online links, which is not usable in your operating system. For example, ($week©) can be cleaned by using =CLEAN($week©) formula which gives (week) as the result. Syntax =CLEAN(Text) Arguments Text: It is the text which will be cleaned, cell number which…

Continue Reading

How to use Excel CHAR Function

Introduction CHAR in excel is a text/string function. CHAR function is used to return a character defined by a number. In windows operating system ANSI/ASCII/Unicode character set is used. This function can be used to define characters which are complex in nature. For example =CHAR(36) returns $ character because it 36 represents $ character in windows character system. Syntax =CHAR(number) Arguments Number: It is a value lying from 1 to 255. Keynotes Excel online only used Character set (9, 10,…

Continue Reading

How to use Excel FIXED function

Introduction FIXED function in excel is a String/Text function. It is a worksheet function. It rounds the given number to a defined number of decimal places. It changes the format of the number into decimal format by using commas and period. Its result is in form of a text representation of the given number.  For example, number 1.548 is rounded by using the formula =FIXED(1.548,1,TRUE) which gives 1.5 as the result. Syntax =FIXED(Number, Decimals, No_Commas) Arguments Number- The number or…

Continue Reading

How to use LEN function in excel

Excel version in which LEN function can work: LEN function will work in Excel for Office 365 Excel for Office 365 for Mac 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 for Android phones Excel Mobile Excel Starter 2010. About LEN function in excel: LEN function calculate the number of character in a selected cell and returns the number…

Continue Reading

How to use CONCATENATE function in excel

Excel version in which CONCATENATE function can work: CONCATENATE function works in Excel for Office 365 Excel for Office 365 for Mac 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 for Android phones Excel Mobile Excel Starter 2010. In Excel 2016, Excel Mobile, and Excel Online, this function has been replaced with the CONCAT function. The CONCATENATE function is…

Continue Reading

How to use SUBSTITUTE function in excel with multiple text replacement

Excel version in which SUBSTITUTE function can work: SUBSTITUTE function will work in Excel for Office 365 Excel for Office 365 for Mac 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 for Android phones Excel Mobile Excel Starter 2010. About SUBSTITUTE function in excel: SUBSTITUTE function is a worksheet text function, this function substitutes or replaces the new text…

Continue Reading

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
Close Menu