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"...
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...
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...
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...