How to compare two text strings while considering the Upper and Lower Case - EXACT FUNCTION

If you use an Equal to (=) for two text strings with exactly same text but different casing, you will get a true result. Therefore it is best to use the EXACT function with text strings.

The Excel EXACT function compares two text strings, taking into account upper and lower case characters, and returns TRUE if they are the same, and FALSE if not. EXACT is case-sensitive.

Purpose Compare two text strings Return value A boolean value (TRUE or FALSE) Syntax =EXACT (text1, text2) Arguments text1 - The first text string to compare. text2 - The second text string to compare.

Usage notes The EXACT function compares two text strings in a case-sensitive manner. If the two strings are exactly the same, EXACT returns TRUE. If the two strings are not the same (taking into account upper and lower case) EXACT returns FALSE.

------------------------

Welcome to Excel is Simple. A place where excel is taught in the dumbest possible way. You will find every type of excel tutorial; excel 2013 tutorial for beginners, excel 2010 tutorial for beginners, excel formulas and functions, excel pivot table tutorial, excel vlookup. Aptly this is one place which has all excel tutorial for beginners. Subscribe to my channel at http://www.youtube.com/user/excelissimple?sub_confirmation=1 Want some focused playlists. Click here and lean back: The IF formula explained: https://www.youtube.com/playlist?list=PLRJY-_DDvSgK7khaQJLqhry-PELQ0hLTe All excel formulas in one place: https://www.youtube.com/playlist?list=PLRJY-_DDvSgKsM7G8qQEAa3oWLDCUn401 Excel basics if you have just started: https://www.youtube.com/playlist?list=PLRJY-_DDvSgLUOnfRBwVQYZVVzOxaVz76

Stay connected at: Facebook: https://web.facebook.com/excelissimple Google Plus: google.com/+excelissimplenow

Share, like and post any questions on the videos ... https://www.youtube.com/watch?v=AVLRerq9Fd8