EXACT

Formulas / EXACT
Compare strings of text.
=EXACT(text1,text2)
  • text1 - The first text string
  • text2 - The second text string

Examples

  • =EXACT("Hello", "Hello")

    The EXACT function can be used to compare two strings for equality. For example, the formula returns TRUE, since the two strings "Hello" are the same.

  • =EXACT("Hello", "hello")

    The EXACT function is case sensitive. For example, the formula returns FALSE, since "Hello" and "hello" are not the same string.

  • =EXACT("Hello", "Hello World")

    The EXACT function can be used to compare strings of different lengths. For example, the formula returns FALSE, since the two strings are not the same.


Summary

The EXACT function is a convenient tool to verify the accuracy of text strings that are added to documents. It is an efficient way to ensure that a document is free of errors.

  • EXACT is a function designed to compare text strings. It takes two arguments, text1 and text2, both of which are required.

Frequently Asked Questions

What is the EXACT function?
The EXACT function is a formula in Sourcetable that tests strings to see if they are exactly the same. It ignores formatting differences, such as font size or color, so it is useful for comparing text entered in a document.
What can I use the EXACT function for?
The EXACT function is used to compare two strings for exact matches. It is useful for ensuring accuracy when entering text into a spreadsheet or comparing two documents.
How do I use the EXACT function?
The EXACT function can be used by entering the formula into a cell and filling in the required parameters. The formula is as follows:
  • EXACT(text1, text2)
Replace 'text1' and 'text2' with the two strings you want to compare. The function will return either TRUE or FALSE depending on the result of the comparison.
Are there any limitations on the EXACT function?
The EXACT function only works with text strings and can only compare two strings at a time. It cannot compare more than two strings or other types of data, such as numbers.

Related Functions

Sourcetable Logo

Work smarter

Al is here to help. Leverage the latest models to
analyze spreadsheets, enrich data, and create reports.

Drop CSV