Compare cell values to see if they are EXACT (case sensitive) or EQUAL (not case sensitive).
“Case Sensitive:
=EXACT([Text1],[Text2])
Converts to Proper Case then Compares:
=EXACT(PROPER(Text1),PROPER(Text2))”
Go to the main page
-
8
Feb 10Compare Column Contents
Posted by Sandoval
0 comments
Go to the main page
Recent Posts- Can not add the user because a user with that name already exists …
- With WSS3 (or MOSS 2007) and Outlook 2007, we have the ability to not only view activity from multiple calendar sources in one virtual calendar view, but we can also edit these SharePoint calendars directly from Outlook.
- Illegal Characters
- Using TODAY As a calculated column
- How to Repair/Replace a broken SharePoint List Form
TagsAlerts Attachments Calculated Columns Calendar Calendars Checkbox Compare Values Concatenate Contains Crawl Customize Date Field Edit Page Error Folders Form Letter Formulas & Functions History hyperlinks If Then Statement Illegal Characters index indexing InfoPath LDAP Query Master Page Migrate Minutes Move Content Multiple Items Notes Office Outlook Integration Repeat Characters Server Limits SharePoint Designer Solid Line SSP stsadm Task Pane Today Truncate URL Visio Word Count
-
Archives
-
Categories
Posts Feed