• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search results

  1. C

    Copying certain text from within a cell and pasting in the next column, same row

    Luke M, Thank you very much for your time spent on this! It's working like a charm :) I wish you all the best. Goodbye.
  2. C

    Copying certain text from within a cell and pasting in the next column, same row

    Hi Luke M, So far, extremely nice :) Thanks. I've added the replacement values in the sheet2, and your script to this excel: http://arthur.selfnet.org/text.xlsm (if you enable macros, you'll have a new menu called add-ins, from there you can use your script by clicking the "format data"...
  3. C

    Copying certain text from within a cell and pasting in the next column, same row

    Hi Luke M, I've tested the second version, works perfectly :) Thank you. You're right, the row 274 has a particularity. As far as I can see the row 274 it obbeys the same data format between brackets (???.??). I'm also seeying the other rows like 241 which as well have 2 sets of brackets but...
  4. C

    Copying certain text from within a cell and pasting in the next column, same row

    hi mercatog: Thank you for your time, really appreciated. It seems that Luke's VB script it's working just fine also with the exception cells so I'll try to stick with it. Hi Luke M, I've tried directly your macro, it works like a charm :) thank you very much for your time and for your...
  5. C

    Copying certain text from within a cell and pasting in the next column, same row

    Hi guys, I wish to advancely format a an Excel doc which can be found here: http://arthur.selfnet.org/text.xlsx I'll split the actions for a better understanding: a) I wish to copy the text from the beginning of the cell until the beginning of the first open bracket "(" ex. in cell...
Back
Top