Lesson 18: Excel String Functions

Lesson 18: Excel String Functions

Question 

1. How to use Exact, Lower, Upper and Proper Functions?

1. EXACT 

Description

The Microsoft Excel EXACT function compares two strings and returns TRUE if both values are the same. Otherwise, it will return FALSE.

The EXACT function is a built-in function in Excel that is categorized as a String/Text Function. It can be used as a worksheet function (WS) in Excel. As a worksheet function, the EXACT function can be entered as part of a formula in a cell of a worksheet.

Syntax

The syntax for the EXACT function in Microsoft Excel is:

EXACT( text1, text2 )

Parameters or Arguments

text1 and text2

The two string values to compare.

Returns

The EXACT function returns TRUE if the two strings are the same.
The EXACT function returns FALSE if the two strings are different.

Note

• The EXACT function is case-sensitive when it compares the two strings.

2. LOWER

Description

The Microsoft Excel LOWER function converts all letters in the specified string to lowercase. If there are characters in the string that are not letters, they are unaffected by this function.

The LOWER function is a built-in function in Excel that is categorized as a String/Text Function. It can be used as a worksheet function (WS) in Excel. As a worksheet function, the LOWER function can be entered as part of a formula in a cell of a worksheet.

Syntax

The syntax for the LOWER function in Microsoft Excel is:

LOWER( text )

3. PROPER

Description

The Microsoft Excel PROPER function sets the first character in each word to uppercase and the rest to lowercase.

The PROPER function is a built-in function in Excel that is categorized as a String/Text Function. It can be used as a worksheet function (WS) in Excel. As a worksheet function, the PROPER function can be entered as part of a formula in a cell of a worksheet.

Syntax

The syntax for the PROPER function in Microsoft Excel is:

PROPER( text )

4. UPPER

Description

The Microsoft Excel UPPER function allows you to convert text to all uppercase.

The UPPER function is a built-in function in Excel that is categorized as a String/Text Function. It can be used as a worksheet function (WS) in Excel. As a worksheet function, the UPPER function can be entered as part of a formula in a cell of a worksheet.

Syntax

The syntax for the UPPER function in Microsoft Excel is:

UPPER( text )