EXACT

Tests whether two strings are identical.

Sample Usage

EXACT(A1,A2)

EXACT("foo",A3)

Syntax

`EXACT(string1, string2)

string1 - The first string to compare
string2 - The second string to compare

Notes

EXACT requires the two strings to have the exact same characters, including identical case and identical spaces or hidden characters.

Examples

[フレーム]

Need more help?

Try these next steps:

Post to the help community Get answers from community members

true

Text

1 of 43
Google Sheets function list
2 of 43
ARABIC
3 of 43
ASC function
4 of 43
CHAR
5 of 43
CLEAN
6 of 43
CODE
7 of 43
CONCATENATE function
8 of 43
DOLLAR
9 of 43
EXACT
10 of 43
FIND function
11 of 43
FINDB
12 of 43
FIXED
13 of 43
JOIN function
14 of 43
LEFT
15 of 43
LEFTB function
16 of 43
LEN
17 of 43
LENB function
18 of 43
LOWER
19 of 43
MID
20 of 43
MIDB function
21 of 43
PROPER
22 of 43
REGEXEXTRACT
23 of 43
REGEXMATCH
24 of 43
REGEXREPLACE
25 of 43
REPLACE
26 of 43
REPLACEB function
27 of 43
REPT
28 of 43
RIGHT
29 of 43
RIGHTB function
30 of 43
ROMAN
31 of 43
SEARCH
32 of 43
SEARCHB
33 of 43
SPLIT function
34 of 43
SUBSTITUTE
35 of 43
T
36 of 43
TEXT
37 of 43
TRIM function
38 of 43
UNICHAR function
39 of 43
UNICODE function
40 of 43
UPPER function
41 of 43
VALUE
42 of 43
TEXTJOIN
43 of 43
BAHTTEXT

Visit the Learning Center

Using Google products, like Google Docs, at work or school? Try powerful tips, tutorials, and templates. Learn to work on Office files without installing Office, create dynamic project plans and team calendars, auto-organize your inbox, and more.

Clear search

Close search

Google apps

Main menu

15538916178067434768

true

Search Help Center

false

true

false