+ Reply to Thread
Results 1 to 6 of 6

If Cell Contains three strings, return data in adjacent cell

Hybrid View

  1. 01-11-2020, 08:08 AM #1
    roc123456789
    roc123456789 is offline
    Registered User
    Join Date
    01-10-2020
    Location
    canada
    MS-Off Ver
    2017
    Posts
    3
    I do have multiple records with XX in them but I want to eliminate all of them. Is there a way to clean the data using the formula ?
    Last edited by AliGW; 01-11-2020 at 09:03 AM. Reason: Please don't quote unnecessarily!
    Reply With QuoteRegister To Reply
  2. 01-11-2020, 08:42 AM #2
    Pete_UK
    Pete_UK is offline
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    25,463

    Re: If Cell Contains three strings, return data in adjacent cell

    It doesn't matter if you have multiple records with XX in them, as they will be ignored.

    Also, please do not quote the previous message - it is just clutter. Use the Reply button rather than Reply With Quote.

    Pete
    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. [SOLVED] Find Multiple Text Strings in Column, return the 9 cell strings below
    By BoExcels in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-05-2019, 09:56 AM
  2. Check for strings in each cell and print strings in adjacent cell if they appear
    By Pawtang in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-21-2019, 10:54 AM
  3. [SOLVED] Trying to compare one cell with a list of cells and return data in adjacent cell on match
    By possumbarnes in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-08-2019, 10:41 AM
  4. Vlookup formula on duplicates, then find max value in adjacent cell, return adjacent cell
    By comohelp in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-21-2015, 05:10 PM
  5. Do not return a value when adjacent cell in two columns of data is empty
    By randinator in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 03-03-2014, 01:53 PM
  6. Compare text strings in two columns and return text from adjacent cell
    By mohitroshan in forum Excel General
    Replies: 6
    Last Post: 02-28-2013, 11:27 AM
  7. Search for an array of strings in a single cell and display adjacent cell value
    By tbabu in forum Excel General
    Replies: 2
    Last Post: 12-18-2009, 10:59 AM

Tags for this Thread

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