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
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.

Search
Clear search
Close search
Google apps
Main menu