Double particular data in Excel columns

  • Hi,

    I have an excel with list names in column A as below

    DEM_1000987645__Adam sela_Retailerlist_200098.pdf

    SEM_1000987435__Joe Dien _Rmprocruitlist_200038.pdf

    I want the same names in column B in this pattern

    DEM_1000987645__1000987645_Adam sela_Retailerlist_200098.pdf

    SEM_1000987435__1000987435_Joe Dien _Rmprocruitlist_200038.pdf


    The 10 digit code number need to be repeated twice


    Kindly help me to develop a macro for the above scenario


    Regards,

    Subhash

  • Hi,


    If my understanding is correct, you can test following macro



    Hope this will help

    :)

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Thumbs Up" icon, below, in the bottom right corner:)

  • Once you have tested the macro, feel free to share your comments

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Thumbs Up" icon, below, in the bottom right corner:)

  • Hi Carim,

    Thanks for your quick response.


    I have the excel file in "D:\Test\Final.xlsx"

    Can you change the above code to open that file and add the new column with the requested format .


    Regards,

    Subhash

  • You do not mention anything about how the macro performs ...???


    Does it produce ... or not ... the expected result ...???

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Thumbs Up" icon, below, in the bottom right corner:)

  • The macro ran successfully but there is no data in that particular file where I added the code...


    Quite obviously ... if you run a macro ...in an empty file ... with NO DATA ...


    it will be quite difficult to determine if the macro works fine or not ...!!!


    =O=O=O

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Thumbs Up" icon, below, in the bottom right corner:)

  • BEFORE going any further ... the BARE minimum is to be sure the macro operates as expected ...:!:

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Thumbs Up" icon, below, in the bottom right corner:)