+ Reply to Thread
Results 1 to 2 of 2

If text in cell exactly 'this' ,delete, otherwise do nothing formula

  1. #1
    Registered User
    Join Date
    12-04-2012
    Location
    United States
    MS-Off Ver
    Excel 20010 Pro
    Posts
    1

    If text in cell exactly 'this' ,delete, otherwise do nothing formula

    First posting and new to excel formulas and functions.

    Want a formula that determines if a text in a cell reads (exact($c5,"Delivered") otherwise delete "" and if not, keep text in cell the same.

    Need assistance finishing this formula if this is possible. =IF(exact($c1,"Delivered"),"",xxxxxx) where xxxxxx reads the text already in the cell.

    Text in cell now:
    C1 = Delivered
    C2 = Not Delivered
    C3 = Not Delivered
    C4 = Delivered

    This is what I want to display:
    C1 =
    C2 = Not Delivered
    C3 = Not Delivered
    C4 =

    Again new to excel formula and can't seem to figure this last part out even after search internet.
    thanks

  2. #2
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft Excel for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    28,529

    Re: If text in cell exactly 'this' ,delete, otherwise do nothing formula

    in D1

    =IF(exact($c1,"Delivered"),"",$C1)

    You cannot put the formula in C1 as you will get a "circular reference" error so put in a another column and then copy/paste special values into C

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Formula to delete words from text only if text in over certain amount of characters
    By erikpaulsen in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 06-03-2015, 05:21 PM
  2. How to delete rows that contain certain text in a cell using a formula
    By panchovilla1221 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 05-27-2014, 09:00 PM
  3. [SOLVED] Delete a row if a cell contains certain text as part of a text string
    By Steve2107 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-15-2014, 07:49 PM
  4. [SOLVED] Find row cell containing specific text, then delete all rows ABOVE that cell
    By ks100 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 12-20-2013, 02:02 PM
  5. [SOLVED] If Or statement to check cell text and delete entire row if text is found
    By VBA FTW in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-08-2013, 11:46 AM
  6. If text in cell contains text found in another cell, delete row.
    By BPSJACK in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-28-2012, 09:42 AM
  7. Find and delete text from a cell with lots of text.
    By leonardzen in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 06-22-2011, 10:52 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1