Nous sommes aussi sur LinkedIn, AMEPBIUG
salam alikoum oustad mehdi , I modified the formula you send me( in case there is no number in the names), and I come up with another one using IFERROR the cool thing is with file timing formulas to see the fastest one : yours (=LEFT(J5;MIN(IF(ISNUMBER(FIND({0;1;2;3;4;5;6;7;8;9};J5));FIND({0;1;2;3;4;5;6;7;8;9};J5)))-2) ...
yes! great one, with some theory five stars oustade ------------------------------ Abdelkader Gharbi ACCOUNTANT +213558893019 ------------------------------
Salam @Abdelkader Gharbi , First of all, if ealy there is no clear pattern you cannot Apply an Excel formula because if you want to write a formula you need to set assumptions based on a pattern on which you think your data can be processed. So to find ...
salam alikoum I send this file, a formula for text without a clear pattern if someone has a better solution (with a formula not power query neither flash fill ) let me know ------------------------------ Abdelkader Gharbi ACCOUNTANT +213558893019 - ...
Great, waiting for your conclusiion ------------------------------ Regards Mehdi HAMMADI CoGitar / 23389830 mehdi.hammadi@cogitar.com ------------------------------