STRSAMEEX function

Microsoft Office ShapeSheet

STRSAMEEX function

See also

Determines whether strings are the same. It returns TRUE if they are the same and FALSE if they aren't. Use this function to compare multi-byte strings or to do comparisons using case rules for a specific locale.

Syntax

STRSAMEEX ("string1", "string2", localeID, flag)

string1

The first string to compare.

string2

The second string to compare.

localeID

The locale ID code.

flag

A bit that specifies the type of comparison.

Remarks

You can use a combination of any of the following flags with the STRSAMEEX function.

Flag

Description

1

Ignore case.

2

Ignore non-spacing characters.

4

Ignore symbols.

4096

Treat punctuation the same as symbols.

65536

Don't differentiate between Hiragana and Katakana characters.

131072

Don't differentiate between a single-byte character and the same character as a double-byte character.