Results 1 to 4 of 4

Thread: If cell contains text, then remove this text

  1. #1

    If cell contains text, then remove this text

    Register for a FREE account, and/
    or Log in to avoid these ads!


    Is there any formula/macros for the following issue?

    If cell contains some word/text, then this word should be removed from the cell, while the other text remains in the cell.

    Like here word "Okay" should be removed, while other text stays
    See the attachment for the reference.

    Attached Files Attached Files

  2. #2
    Magician NoS's Avatar
    Join Date
    Jan 2013
    British Columbia
    Excel Version
    Excel 2010

    if cell contains SPECIFIC text, remove it

    Hi Caladbolg17

    This won't answer your question, but more like re-phrase it, in hopes of the "formula boys" arriving on the scene.

    The cells you are working with have values (ie: the text/words) something like this

    Good & chr(10) & Great & chr(10) & Okay

    and display the words in the cell one below the other. You would like to remove the word Okay.

    Is Okay the only word you ever want to remove?
    Does the location of Okay change within the different cells?
    If there are other words that need removed as well? If yes, are they in a list in the workbook somewhere?

  3. #3
    Well, Okay is the only word I want to remove, the location of the word is different for some cells.

  4. #4
    Super Moderator NBVC's Avatar
    Join Date
    May 2011
    Mississauga, Canada
    Excel Version
    Excel 2016
    Select the range, do a CTRL+H in the Find What field enter: Okay

    in the Replace With field, don't enter anything.

    Click Replace All.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts