STRSAMEEX Function

Office 2013 and later

Last modified: March 09, 2015

Applies to: Office 2013 | Visio 2013

Determines whether two strings are the same.

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

Parameters

Name

Required/Optional

Data Type

Description

string1

Required

String

The first string to compare.

string2

Required

String

The second string to compare.

localeID

Required

Numeric

The locale ID code.

flag

Required

Numeric

A bit that specifies the type of comparison.

Return Value

Boolean

STRSAMEEX returns TRUE if both input strings are the same and FALSE if they aren't. Use this function to compare multi-byte strings or to do comparisons that use case rules for a specific locale.

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.

Show: