The Microsoft Excel LOWER function converts all letters in the specified string to lowercase. Numbers and punctuation are not affected. Syntax The syntax for the LOWER function in Microsoft Excel is: =LOWER( text ) Parameters or Arguments text The string […]

The SEARCH function in Excel is very similar to FIND in that it also returns the location of a substring in a text string. Unlike FIND, the SEARCH function is case-insensitive and it allows using the wildcard characters. Syntax The […]

FIND function can be used when you want to locate a text string within another text string and find its position. It returns a number that represents the starting position of the string you are finding in another string. Syntax […]

The Excel CLEAN function removes all non-printable characters from a supplied text string. The function is designed to remove the non-printable characters, represented by numbers 0 to 31 of the 7-bit ASCII code, which are often found at the start […]

The Excel TRIM function strips extra spaces from text, leaving only a single space between words and no space characters at the start or end of the text. Syntax The syntax for the TRIM function in Microsoft Excel is: TRIM( […]

The Excel defines MID function as a formula that “Returns the characters from the middle of a text string, given a starting position and length.” Syntax The syntax for the MID function in Microsoft Excel is: MID( text, start_position, number_of_characters […]

The Excel LEFT function allows you to extract a substring from a string, starting from the left-most character. Syntax The syntax for the LEFT function in Microsoft Excel is: LEFT( text, [num_chars] ) Parameters or Arguments text The string that […]

The Excel RIGHT function extracts a given number of characters from the right side of a supplied text string. Syntax The syntax for the RIGHT function in Microsoft Excel is: RIGHT( text, [num_chars] ) Parameters or Arguments text The string […]