The Excel TEXTJOIN function concatenates (joins) values with a given delimiter. Unlike the CONCAT function, TEXTJOIN allows you to supply a range of cells, and has a setting to ignore empty values. Syntax The syntax for the TEXTJOIN function in […]

The Excel Exact function tests if two supplied text strings or values are exactly equal and if so, returns TRUE; Otherwise, the function returns FALSE. The function is case-sensitive. Syntax The syntax for the EXACT function in Microsoft Excel is: […]

The Excel LEN function returns the length of a given text string as the number of characters. LEN will also count characters in numbers, but number formatting is not included. Syntax The syntax for the LEN function in Microsoft Excel […]

The Excel CONCAT function concatenates (joins) values supplied as references or constants. Unlike the CONCATENATE function (which CONCAT replaces), CONCAT allows you to supply a range of cells to join, in addition to individual cell references. Syntax The syntax for […]

The Excel CONCATENATE function concatenates (joins) join up to 30 text items together and returns the result as text. The CONCAT function replaces CONCATENATE in newer versions of Excel. Syntax The syntax for the CONCATENATE function in Microsoft Excel is: […]

The Excel REPT function repeats characters a given number of times. For example, =REPT(“x”,5) returns “xxxx”. Syntax The syntax for the REPT function in Microsoft Excel is: =REPT( text, number ) Parameters or Arguments text The text value to repeat. […]

The Excel Substitute function replaces one or more instances of a given text string, within an original text string. Syntax The syntax for the SUBSTITUTE function in Microsoft Excel is: =SUBSTITUTE( text, old_text, new_text, [Instance] ) Parameters or Arguments text […]

Replace replaces part of a text string, based on the number of characters you specify, with a different text string. Syntax The syntax for the REPLACE function in Microsoft Excel is: =REPLACE( old_text, start_num, num_chars, new_text ) Parameters or Arguments […]

The Microsoft Excel PROPER function sets the first character in each word to uppercase and the rest to lowercase. Warning: as well as the first letter of every word, letters following numbers or other punctuation are converted to upper case […]

The Excel UPPER function returns a upper-case version of a given text string. Numbers and punctuation are not affected. Syntax The syntax for the UPPER function in Microsoft Excel is: =UPPER( text ) Parameters or Arguments text The string that […]