Text functions

How to use the UNICODE function

Use the UNICODE function to return a Unicode number based on a character. Excel Function Syntax UNICHAR(text) Arguments text Required. […]

How to use the UNICHAR function

Use the UNICHAR function to calculate a character based on a number. Excel Function Syntax UNICHAR(number) Arguments number Required. The […]

How to use the CONCATENATE function

The CONCATENATE function lets you add text strings into one single text string. The function has been replaced by the […]

How to use the ASC function

The ASC function converts full-width (double-byte) characters to half-width (single-byte) characters. This function is for double-byte character set (DBCS) languages. […]

How to use the FIXED function

The FIXED function rounds a number to the specified number of decimals, formats the number in decimal format using a […]

How to use the CONCAT function

The CONCAT function concatenates values from multiple cells. There is, however, no delimiting character or a way to ignore empty […]

How to use the T function

The T function returns a text value if the argument is a text value. Formula in cell C3: =T(B3) The […]

How to use the FIND function

The FIND function returns the position of a specific string in another string, reading left to right. Note, the FIND function […]

How to use the VALUE function

Converts a text string that represents a number to a number. This function is included for compatibility with other software. […]

How to use the CLEAN function

The CLEAN function deletes nonprintable characters in a value, more specifically, it is designed to delete the first 32 nonprinting […]

How to use the LEN function

The LEN function returns the number of characters in a cell value. Formula in cell D3: =LEN(B3) Cell B7 contains […]

How to use the CHAR function

Use CHAR function to convert a number to the corresponding character. This is determined by your computers character set. Windows ANSI […]

How to use the CODE function

The CODE function returns a specific number for the first character of the text argument, determined by your computers character set. […]

How to use the LOWER function

The LOWER function converts a value to lower case letters. Formula in cell C3: =LOWER(B3) Excel Function Syntax LOWER(text) Arguments […]

How to use the REPT function

The REPT function repeats a specific text a chosen number of times. Formula in cell D3: =REPT(B3,C3) Excel Function Syntax […]

How to use the SUBSTITUTE function

The SUBSTITUTE function replaces a specific text string in a value. Case sensitive. Formula in cell E3: =SUBSTITUTE(B3,C3,D3) Excel Function […]

How to use the UPPER function

Converts a value to upper case letters. Formula in cell C3: =UPPER(B3) Excel Function Syntax UPPER(text) Arguments text Value to convert. Required.

How to use the EXACT function

The EXACT function allows you to check if two values are precisely the same, it returns TRUE or FALSE. The […]

How to use the TRIM function

The picture above shows you values that have multiple leading and trailing blanks, sometimes also between words. The TRIM function […]

How to use the RIGHT function

The RIGHT function extracts a specific number of characters always starting from the right. Excel Function Syntax RIGHT(text,[num_chars]) Arguments text […]

How to use the LEFT function

The LEFT function extracts a specific number of characters always starting from the left. Excel Function Syntax LEFT(text, [num_chars]) Arguments […]

How to use the MID function

The MID function returns a substring from a string based on the starting position and the number of characters you want […]

How to use the TEXT function

Excel function syntax TEXT(value, format_text) Converts a value to text in a specific number format. Arguments value - The string […]

How to use the TEXTJOIN function

The TEXTJOIN function is a new function for office 365 subscribers, it is like the CONCATENATE function on steroids or what the CONCATENATE function […]

How to use the SEARCH function

Returns a number representing the position a substring is, if found in a textstring. FIND is case sensitive and SEARCH is not.