Hi gang,
If (B3 contains "wow", C3="wow", nothing)
Could someone help me with this statement. B3 contains text, a sentence, not just one word.
tks
jc
Results 1 to 3 of 3
-
2 Star Lounger
- Join Date
- Dec 2000
- Location
- Montreal, Quebec, Canada
- Posts
- 115
- Thanks
- 0
- Thanked 0 Times in 0 Posts
2005-12-16 16:31If (B3 contains 'text') (Office 2003)
-
Subscribe to get a FREE chapter from Windows 7 The Missing Manual
This month, every Windows Secrets subscriber can download a one-chapter excerpt of Windows 7: The Missing Manual.Windows 7: The Missing Manual provides valuable information to help you overcome these difficulties in learning a new operating system. Subscribe today to download your free excerpt.
-
Plutonium Lounger
- Join Date
- Mar 2002
- Posts
- 84,353
- Thanks
- 0
- Thanked 10 Times in 10 Posts
2005-12-16 16:37Re: If (B3 contains 'text') (Office 2003)
Try this in cell C3:
<code>
=IF(ISERROR(FIND("wow",B3)),"","wow")
</code>
The FIND function returns a number if "wow" is found in B3, and an error #VALUE if not.
-
2 Star Lounger
- Join Date
- Dec 2000
- Location
- Montreal, Quebec, Canada
- Posts
- 115
- Thanks
- 0
- Thanked 0 Times in 0 Posts
2005-12-16 19:52Re: If (B3 contains 'text') (Office 2003)
Perfect. Thanks Hans.
