by Rajesh Saraogi | Jul 16, 2020 | Functions
Description TRIM is a text function in Excel. Removes extra spaces from a text string except single space between words. It also remove leading and trailing spaces Syntax TRIM(text) Example TRIM Excel function removes the extra spaces from the text...
by Rajesh Saraogi | Jul 16, 2020 | Functions
Description TEXTJOIN is a text function in Excel. Using this function you can join value from multiple cells or a range with a delimiter. This function has an option to consider or ignore empty cells Syntax TEXTJOIN(delimiter, ignore_empty, text1, [text2], …) Example...
by Rajesh Saraogi | Jul 16, 2020 | Functions
Description TEXT is categorized as text function in Excel. It converts the value into text in the specified format. Having two arguments where first one is value, the value you want to convert into text and other one is format, the format in which you want to...
by Rajesh Saraogi | Jul 16, 2020 | Functions
Description T is a text function in Excel. Returns text for text value and empty string for number, date and logical value. You will not require to use this function, but it’s available for compatibility with other spreadsheet programs Syntax T(value) Example T...
by Rajesh Saraogi | Jul 16, 2020 | Functions
Description SUBSTITUTE is a text function in Excel, use it to replace one or more characters from a text string. Having four arguments, first three are mandatory and last one is optional. First one is text from which you want to replace the character(s). Second is...
by Rajesh Saraogi | Jul 16, 2020 | Functions
Description SEARCH is a text function in Excel. Having three arguments, first two arguments are mandatory and third one is optional. First argument is find_text, the text you want to search, second one is within_text, the text string in which you want to search and...
