+ Reply to Thread
Results 1 to 5 of 5

Text within a string

  1. 01-22-2020, 03:38 PM #1
    soapinmama
    soapinmama is offline
    Registered User
    Join Date
    08-03-2012
    Location
    Wisconsin
    MS-Off Ver
    Excel 2010
    Posts
    4

    Text within a string

    Indications NAFLD AF
    NAFLD X X
    NAFLD, AF X X
    AF X

    =IF(ISNUMBER(SEARCH($B$1,A2)),"X","")

    The problem is the formula is not able to tell the difference from NAFLD and AF. Any ideas?

    ~kat
    Reply With QuoteRegister To Reply
  2. 01-22-2020, 03:44 PM #2
    Fluff13
    Fluff13 is offline
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,078

    Re: Text within a string

    Hi & welcome to the board.
    How about
    =IF(ISNUMBER(SEARCH(" "&B$1&","," "&$A2&",")),"X","")
    Reply With QuoteRegister To Reply
  3. 01-22-2020, 03:44 PM #3
    BMV
    BMV is offline
    Forum Expert BMV's Avatar
    Join Date
    01-13-2020
    Location
    St-Petersburg, Russia
    MS-Off Ver
    2013-2016
    Posts
    1,329

    Re: Text within a string

    Del. I miss
    Last edited by BMV; 01-22-2020 at 03:47 PM.
    Reply With QuoteRegister To Reply
  4. 01-22-2020, 03:47 PM #4
    soapinmama
    soapinmama is offline
    Registered User
    Join Date
    08-03-2012
    Location
    Wisconsin
    MS-Off Ver
    Excel 2010
    Posts
    4

    Re: Text within a string

    Fluff13, THANK YOU! That seemed to have done it. I couldn't figure out how to put the comma deliminator!
    Reply With QuoteRegister To Reply
  5. 01-22-2020, 04:27 PM #5
    Fluff13
    Fluff13 is offline
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,078

    Re: Text within a string

    You're welcome & thanks for the feedback
    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)

Similar Threads

  1. How to delete entire row if text string from first column match text string from text file
    By alban7 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-27-2016, 12:30 AM
  2. Storing complex text string into variable. Text string contains html or xml code.
    By jakopak in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-20-2015, 04:54 AM
  3. Search text string and return multiple results depending on content of text string
    By adamf1987 in forum Excel General
    Replies: 2
    Last Post: 05-14-2015, 01:30 PM
  4. Advanced Split Function: Need to pull text string in quotes, within a text string
    By Zamboni in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 11-27-2013, 04:38 PM
  5. [SOLVED] Find partial text string within another text string return original text into cell.
    By mikey42979 in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 06-17-2013, 02:58 PM
  6. copy only fonts(text color) from one string of text to another string of text
    By JMJ123 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 05-06-2013, 04:22 AM

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