Consulting

Results 1 to 2 of 2

Thread: Help create Macro remove multi-lines duplicate characters

  1. #1

    Red face Help create Macro remove multi-lines duplicate characters

    Hello, i got stuck with my work, example please see on image exp.jpg
    If MACRO find
    Line 1: "TIP:"
    Line 2: "Question_" //only count from begin of line or we can understand it's 9 characters from left = Question_)
    Line 3: "Question_" //only count from begin of line or we can understand it's 9 characters from left = Question_)

    Then Macro will remove "Question_" in line 2 but keep all words after Question_.
    ------------Before Macro run
    Question_1. Some body cleans the room every day.
    (A) The room every day is cleaned.
    (B) The room is every day cleaned.
    (C) The room is cleaned every day.
    (D) The room is cleaned by somebody every day.
    ####
    Answer (C)
    TIP:
    Question_1 qweqweqweqwe
    Question_2. They cancelled all flights because of fog.
    (A) All flights because of fog were cancelled.
    (B) All flight were cancelled because of fog.
    (C) All flights were because of fog cancelled.
    (D) All flights were cancelled by them because of fog
    ####
    Answer (B)
    TIP:
    Question_2 bcvbcvbvcb

    --------After macro run
    Question_1. Some body cleans the room every day.
    (A) The room every day is cleaned.
    (B) The room is every day cleaned.
    (C) The room is cleaned every day.
    (D) The room is cleaned by somebody every day.
    ####
    Answer (C)
    TIP:
    1 qweqweqweqwe
    Question_2. They cancelled all flights because of fog.
    (A) All flights because of fog were cancelled.
    (B) All flight were cancelled because of fog.
    (C) All flights were because of fog cancelled.
    (D) All flights were cancelled by them because of fog
    ####
    Answer (B)
    TIP:
    2 bcvbcvbvcb


    ----------------Thank for reading and helping me (Y)!
    Regards <3

  2. #2
    Administrator
    VP-Knowledge Base
    VBAX Grand Master mdmackillop's Avatar
    Joined
    May 2004
    Location
    Scotland
    Posts
    14,489
    Location
    MVP (Excel 2008-2010)

    Post a workbook with sample data and layout if you want a quicker solution.


    To help indent your macros try Smart Indent

    Please remember to mark threads 'Solved'

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
  •