+ Reply to Thread
Results 1 to 3 of 3

Function to delete text from all cells that do not contain specific text values?

  1. #1
    Registered User
    Join Date
    05-17-2018
    Location
    Chicago, United States
    MS-Off Ver
    2013
    Posts
    1

    Question Function to delete text from all cells that do not contain specific text values?

    Here is the function I have so far:

    Please Login or Register  to view this content.
    This works correctly and deletes the text from all cells that do not contain "D.R." However, I also want to keep cells that contain the text "F.G." and "WIP".
    I'm not sure how the syntax of the OR operator would work in this situation. Any help is appreciated. Thanks.

  2. #2
    Forum Expert
    Join Date
    10-06-2008
    Location
    Canada
    MS-Off Ver
    2007 / 2013
    Posts
    5,528

    Re: Function to delete text from all cells that do not contain specific text values?

    Please Login or Register  to view this content.

  3. #3
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,080

    Re: Function to delete text from all cells that do not contain specific text values?

    How about
    Please Login or Register  to view this content.

+ 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] sub to put values of all cells that begins with a specific text, separated by commas
    By namy77 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 09-27-2016, 11:16 AM
  2. User form text box generating values in specific cells
    By jeck876 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-22-2016, 05:49 PM
  3. Delete Columns if cells in row 5 has a specific Text
    By VKu in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 03-19-2015, 08:52 AM
  4. [SOLVED] Counting Specific Text Occurences in Cells Adjacent to Particular Values
    By lowlybroker in forum Excel General
    Replies: 7
    Last Post: 10-21-2013, 12:07 PM
  5. [SOLVED] Cells values to be check and replace with specific text
    By amolryeolekar in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-18-2013, 02:44 AM
  6. Delete rows which do not meet specific criteria (text values)
    By dim06 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-28-2012, 09:54 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1