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 […]

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( […]