How to use Excel TEXTJOIN Function

Introduction TEXTJOIN function are text/string function in excel. It is used to join multiple text strings with a delimiter attached to it. It also has option to ignore empty values and can also be used to join a range of cells. Syntax =TEXTJOIN(delimiter, ignore_empty, text1, text2) Arguments Delimiter: It is the separator between text values. … Read more

How to use Excel FIND, FINDB Function

Introduction FIND, FINDB in excel is a text/string function. This function finds one text string within another string and returns its position as a number. This is a case sensitive function. For example, if we have a text string in cell A4 and we wants to find the position of ‘P’ in this string, then … Read more

How to use Excel YEARFRAC function

Introduction YEARFRAC function in Excel is a type of DATE/TIME function. It used to find year between two dates which can also be in form of a fraction and result can be in form of decimals. It is a worksheet function and can be entered in a cell. Syntax =YEARFRAC(Start_Date, End_Date, Basis) Arguments Start_Date:- A … Read more

How to use Excel HOUR Function

Introduction HOUR function in Excel is a type of DATE/TIME function. This function is used to find hours from a given time. It gives result in form of numbers ranging from 0(12:00 AM) to 23(11:00 PM). For example, for time 10:15 AM, HOUR function will retrieve 10. HOUR function can also be used with the … Read more

How to use Excel ASC Function

Introduction ACS in excel is a text/string function. It is used in case of double byte character set to convert full width(double-byte) to half width(single-byte) characters. This function is useful for multiple languages and unique characters. For example, =ASC(“PRINCE”)gives PRINCE as the result. Syntax =ASC(Text) Arguments Text: It is the text or reference which contains … Read more

How to use excel DATEVALUE function

Introduction DATEVALUE function in Excel is a type of DATEVALUE/TIME function. This function is used to change a date which is in form of text to a valid excel format and gives result in form of serial number in the Excel date system. For example, formula =DATEVALUE(12/09/2018) gives 43443 as the result.  Syntax =DATEVALUE(Date_Text) Arguments … Read more

How to use Excel DAYS360 Function

Introduction DAYS360 function in Excel is a type of DATE/TIME function. It gives value of the number of days falling between two dates by considering a 360 days year. It does so by considering every month of the year to be consisting of 30 days. This function can be applied to find the number of … Read more

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 … Read more