+ Reply to Thread
Results 1 to 6 of 6

Delete a cell if it contains specific text ("")

  1. 02-27-2019, 01:51 AM #1
    nekmat97
    nekmat97 is offline
    Registered User
    Join Date
    01-16-2018
    Location
    New South Wales
    MS-Off Ver
    2016 64-Bit
    Posts
    34

    Delete a cell if it contains specific text ("")

    Hello everyone,


    I have a spreadsheet with some text on cells it and some cells contain "" in them.

    I was wondering if it's possible to somehow check if a range (i.e. A2:A15) contains only "" in every cell from A2 to A15 and if it does, A1 is to be deleted. But if a string exists in A2:A15, then nothing is done.

    I would appreciate any help and guidance.


    Thanks!
    Attached Files Attached Files
    Last edited by nekmat97; 02-27-2019 at 02:06 AM. Reason: Adding in a sample spreadsheet
    Reply With QuoteRegister To Reply
  2. 02-27-2019, 01:53 AM #2
    YasserKhalil
    YasserKhalil is offline
    Forum Expert
    Join Date
    04-23-2009
    Location
    Matrouh, Egypt
    MS-Off Ver
    Excel 2013
    Posts
    6,892

    Re: Delete a cell if it contains specific text ("")

    Hello
    Can you upload sample of your file? How did you get "" in your range? Is it a result of a formula and then you pasted the range again as values?
    < ----- Please click the little star * next to add reputation if my post helps you
    Visit Forum : From Here
    Reply With QuoteRegister To Reply
  3. 02-27-2019, 02:07 AM #3
    nekmat97
    nekmat97 is offline
    Registered User
    Join Date
    01-16-2018
    Location
    New South Wales
    MS-Off Ver
    2016 64-Bit
    Posts
    34

    Re: Delete a cell if it contains specific text ("")

    Sorry for not posting a sample at the start. I have attached a sample spreadsheet. The ("") is as a result of a formula, in the case of the sample, I'm trying to remove cell A1 since everything after "A" and before "B" is ("").
    Reply With QuoteRegister To Reply
  4. 02-27-2019, 02:23 AM #4
    jindon
    jindon is offline
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,560

    Re: Delete a cell if it contains specific text ("")

    See if this is how you wanted.
    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  5. 02-27-2019, 02:38 AM #5
    nekmat97
    nekmat97 is offline
    Registered User
    Join Date
    01-16-2018
    Location
    New South Wales
    MS-Off Ver
    2016 64-Bit
    Posts
    34

    Re: Delete a cell if it contains specific text ("")

    Thank you so much! Works perfectly.
    Reply With QuoteRegister To Reply
  6. 02-27-2019, 02:51 AM #6
    jindon
    jindon is offline
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,560

    Re: Delete a cell if it contains specific text ("")

    You are welcome and thanks for the rep.

    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
    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. What's wrong with my this formula "=CELL("contents","D" & TEXT(MATCH(MIN(M25:M39),M25:M39"
    By woshichuanqilz in forum Excel General
    Replies: 4
    Last Post: 06-11-2017, 02:03 PM
  2. [SOLVED] Code that copies row of data to another sheet based on text "Complete"/"Delete"
    By Dremzy in forum Excel Programming / VBA / Macros
    Replies: 17
    Last Post: 04-20-2014, 05:51 PM
  3. NEED HELP! Code that copies row of data to another sheet based on text "Complete"/"Delete"
    By Dremzy in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-20-2014, 11:18 AM
  4. [SOLVED] If(Search to say "YES" or "NO" if cell contains specific text
    By Alt= in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-24-2014, 03:23 PM
  5. [SOLVED] Delete Rows if a cell does not equal "Finished" or "Complete"
    By Justair07 in forum Excel Programming / VBA / Macros
    Replies: 16
    Last Post: 09-27-2013, 12:40 PM
  6. [SOLVED] Macro to delete entire roll when the cell has "CLOSED" text
    By ricdamiani in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 08-12-2013, 02:02 AM
  7. "Form and macro" to delete "Active" cell contents.
    By wanty in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-22-2013, 11:33 PM

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