by Rajesh Saraogi | Jul 16, 2020 | Functions
Description LEFT is a text function in Excel. Use it to pick one or more characters from left or beginning of the ‘text’. It has two arguments where one is mandatory and other is optional. In optional argument, where you define the number of characters to be picked is...
by Rajesh Saraogi | Jul 16, 2020 | Functions
Description EXACT is a text function in Excel.It compares two text strings and return TRUE, if both the strings are same otherwise returns FALSE. It is a case sensitive function. Syntax EXACT(text1, text2) Example EXACT returns TRUE as both the text strings are same....
by Rajesh Saraogi | Jul 16, 2020 | Functions
Description CONCAT is a text function in Excel. It’s an improved version of CONCATENATE and was introduced in place of CONCATENATE after removing it’s limitations. CONCAT accepts all kind of range, cell references or text strings, either individually or in...
by Rajesh Saraogi | Jul 16, 2020 | Functions
Description CODE is a text function in Excel. This function returns ASCII code for the character or first character in case a string is provided Syntax CODE(text) Example CODE Excel function returns the numeric code for the character CODE Excel function returns the...
by Rajesh Saraogi | Jul 16, 2020 | Functions
Description CLEAN is a text function in Excel. It is used to remove non printable characters like line break etc. Syntax CLEAN(text) Example CLEAN Excel function removed the non-prinable characters CHAR(3) & CHAR(4) CLEAN Excel function removed the non-prinable...
by Rajesh Saraogi | Jul 14, 2020 | Functions
Description RIGHT is a text function in Excel. Use it to pick one or more characters from right or end of the ‘text’. Having two arguments where one is mandatory and other one is optional. In optional argument, where you define the number of characters to be picked is...
