![]() The EXACT function looks for two values and returns “TRUE” if the value 1 is equal to value 2. This function is a logical function, so it provides true or false as a result. If we want to match or compare two columns with a case sensitive approach, we need to use the Exact function in excel Exact Function In Excel The exact function is a logical function in excel used to compare two strings or data with each other, and it gives us the result whether the both data are an exact match or not. It has eliminated the trailing space in cell B9. We got the result as “TRUE” because we have applied a TRIM function. Now, let us look at the result in cell C9. Below is the way of using the TRIM function. To overcome these kinds of scenarios, we can apply the formula with the TRIM function, which removes all the unwanted space characters.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
March 2023
Categories |