Función de Google Sheets

EXACT

Checks whether two text strings are exactly the same.

Generar una fórmula con IA La misma función en Excel

Esta función funciona igual en Google Sheets que en Excel: misma sintaxis y mismos argumentos.

Sintaxis

EXACT(text1, text2)

The EXACT function compares two text strings and returns TRUE if they are identical, including case sensitivity. It ignores formatting and is useful for verifying data entries where capitalization matters.

Argumentos

text1obligatorioThe first text string to compare.
text2obligatorioThe second text string to compare.

Ejemplos

=EXACT("Apple", "apple")

Resultado: FALSE

Returns FALSE because the function is case-sensitive.

=EXACT("Excel", "Excel")

Resultado: TRUE

Returns TRUE because both strings are identical.

Preguntas frecuentes

Is the EXACT function case-sensitive?

Yes, unlike the standard equal sign (=) operator, EXACT is strictly case-sensitive.

Funciones relacionadas

FIND SEARCH UPPER LOWER