Verify that a cell column contains a sting of text. This formula basis calculation on cell content vs. the entire cell value.
“=ISNUMBER(FIND(“”BD”",[Column1]))”
Go to the main page
-
8
Feb 10Does a Cell Contain a Specific String of Characters?
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