# Use

EXACT function is used to compare different text strings or values and results with TRUE if strings are exactly same otherwise it will return FALSE. It is case-sensitive but ignores formatting differences.

# Syntax

=EXACT(text1, text2)

where, arguments text1 and text2 are different text strings or values, to whom you need to compare.

## Example

To convert text values and strings in the above-mentioned screenshot, do the following steps:

**1. **Go to cell C1, type =EXACT(A1,B1) and press Enter.

In result, Excel will show TRUE if both values match otherwise FALSE will appear.

**2. Copy cell C1** by pressing Ctrl + C and **paste it** to remaining cells by pressing Ctrl + V after **selecting** the particular cell.

## Reasoning Table

Column A | Column B | Formula Results | Reasons |

Alphabets | alphabets | FALSE | Small letter in column B |

Text | Text | TRUE | – |

50 | 50 | FALSE | Value in Column A is 49.9 which has been rounded to 50 |

A BCD | ABCD | FALSE | Space between alphabets in column A |