Consulting

Results 1 to 2 of 2

Thread: VBA: Remove line in cell if substring present

  1. #1

    VBA: Remove line in cell if substring present

    I am looking for a VBA code to remove line in cell if given substring "tiger" present.
    Also if I give special character or combination of numbers it should do the same.
    An example is below:

    Input Example (Column A1) Output Example (Column B1)
    Eat healthy
    What ! you saw a tiger


    2What is that ? A tiger


    ()I live in England




    Eat an apple everyday. What
    Eat healthy
    ()I live in England
    Eat an apple everyday. What
    Eat healthy
    What ! you saw a tiger


    2What is that ? A tiger
    Eat healthy
    What ! you saw a tiger


    2What is that ? A tiger


    ()I live in England




    Eat an apple everyday. What
    ()I live in England
    Eat healthy
    Eat healthy
    ()I live in England
    Eat an apple everyday. What
    ()I live in England
    Eat an apple everyday. What

  2. #2
    one of those sample.
    Attached Files Attached Files

Tags for this Thread

Posting Permissions

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