+ Reply to Thread
Results 1 to 3 of 3

How to auto set a cell when another cell contain a certain string?

  1. 05-11-2017, 09:28 PM #1
    woshichuanqilz
    woshichuanqilz is offline
    Forum Contributor
    Join Date
    08-01-2016
    Location
    China, beijing
    MS-Off Ver
    2016
    Posts
    114

    How to auto set a cell when another cell contain a certain string?

    For example, I want to change the cell A1 to "yes" when B1 value contain the string "abc".


    How to make it ?
    Reply With QuoteRegister To Reply
  2. 05-11-2017, 09:31 PM #2
    southward
    southward is offline
    Valued Forum Contributor
    Join Date
    05-08-2015
    Location
    Uvalde, TX
    MS-Off Ver
    2010
    Posts
    720

    Re: How to auto set a cell when another cell contain a certain string?

    Hi,

    Try this:

    Please Login or Register  to view this content.
    Cheers
    Reply With QuoteRegister To Reply
  3. 05-11-2017, 09:34 PM #3
    NickyC
    NickyC is offline
    Forum Expert
    Join Date
    06-09-2010
    Location
    Australia
    MS-Off Ver
    Excel 2013
    Posts
    1,714

    Re: How to auto set a cell when another cell contain a certain string?

    hi
    or if you want to return yes if A1 includes abc (eg 12345abcde) try this
    Please Login or Register  to view this content.
    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. search cell text in another cell string and return other cell
    By is2_egypt in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-14-2016, 05:30 PM
  2. Need help on String Extraction from a cell based on start string and end string
    By Premnath_vba in forum Office 365
    Replies: 1
    Last Post: 08-07-2015, 04:01 PM
  3. Search cells for a string and when that string exists copy entire cell to another cell
    By nitro535 in forum Excel General
    Replies: 6
    Last Post: 06-05-2015, 09:28 AM
  4. Auto-fill a cell based on a drop down selection in one cell & a formula in another cell
    By Deena C in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 03-20-2014, 10:57 AM
  5. Compare two cells - determine if string in cell 2 is contained within string in cell 1
    By anakaine in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-22-2013, 02:09 AM
  6. Excel 2007 : How to replace a word/string from a cell that contain a string from another cell
    By mike4uuu in forum Excel General
    Replies: 2
    Last Post: 06-01-2011, 09:45 AM
  7. A Macro to replace a string in a cell with a string from another cell???
    By Plica05 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-16-2005, 04:23 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