+ Reply to Thread
Results 1 to 4 of 4

Finding part of a text string in a cell

  1. 06-18-2008, 05:39 PM #1
    Tonro
    Tonro is offline
    Registered User
    Join Date
    06-18-2008
    Posts
    2

    Finding part of a text string in a cell

    I've got the following in Col A:

    Star War VCsi/Fam. Guy
    Star WarsBoston Legal
    Star Wars/AidCsi(All)
    GladiatorDrake & Josh
    Fraiser Star Wars
    HsmHannah Montana
    Harry Potter Star Wars Gladiator

    I would like to return a True or False value in Col B next to any cell that contains the text "Star Wars".

    I've tried =IF(A1="*"&"Star Wars"&"*",TRUE,FALSE) but this gives me a FALSE value.

    I think my problem is with the wildcards.

    Thanks in advance for the help.
    Reply With QuoteRegister To Reply
  2. 06-18-2008, 05:44 PM #2
    VBA Noob
    VBA Noob is offline
    Forum Contributor VBA Noob's Avatar
    Join Date
    04-25-2006
    Location
    London, England
    MS-Off Ver
    xl03 & xl 07(Jan 09)
    Posts
    11,988
    Maybe

    =ISNUMBER(SEARCH("Star War",A1))
    Note i used Star war instead of Star wars as your list as some of each

    VBA Noob
    _________________________________________


    Credo Elvem ipsum etian vivere
    _________________________________________
    A message for cross posters

    Please remember to wrap code.

    Forum Rules

    Please add to your signature if you found this link helpful. Excel links !!!
    Reply With QuoteRegister To Reply
  3. 06-18-2008, 05:44 PM #3
    Ron Coderre
    Ron Coderre is offline
    Forum Expert Ron Coderre's Avatar
    Join Date
    03-22-2005
    Location
    Boston, Massachusetts
    MS-Off Ver
    2013, 2016, O365
    Posts
    6,996

    Finding part of a text string in a cell

    With
    A1: (any text or blank)

    This formula returns TRUE if A1 contains "star wars",
    otherwise it returns FALSE:
    Please Login or Register  to view this content.
    Is that something you can work with?
    Ron
    Former Microsoft MVP - Excel (2006 - 2015)
    Click here to see the Forum Rules
    Reply With QuoteRegister To Reply
  4. 06-18-2008, 05:59 PM #4
    Tonro
    Tonro is offline
    Registered User
    Join Date
    06-18-2008
    Posts
    2

    Thank you

    Both of the solutions posted about work great!
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1