Results 1 to 3 of 3
  1. #1
    2 Star Lounger
    Join Date
    Dec 2000
    Location
    Montreal, Quebec, Canada
    Posts
    115
    Thanks
    0
    Thanked 0 Times in 0 Posts

    If (B3 contains 'text') (Office 2003)

    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

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: 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.

  3. #3
    2 Star Lounger
    Join Date
    Dec 2000
    Location
    Montreal, Quebec, Canada
    Posts
    115
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: If (B3 contains 'text') (Office 2003)

    Perfect. Thanks Hans.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •