For this specific task, =MID(A1;SEARCH("^[A-Z]*[0-9]*";A1);SEARCH("[^0-9]";A1;SEARCH("[0-9]";A1))-1) will do. But @erAck have introduced a new REGEX function for upcoming LO 6.2.
For this specific task, =MID(A1;SEARCH("^[A-Z]*[0-9]*";A1);SEARCH("[^0-9]";A1;SEARCH("[0-9]";A1))-1) will do. But @erAck have introduced a new REGEX function (tdf#113977) for upcoming LO 6.2.
For this specific task, =MID(A1;SEARCH("^[A-Z]*[0-9]*";A1);SEARCH("[^0-9]";A1;SEARCH("[0-9]";A1))-1) will do. But @erAck have has introduced a new REGEX function (tdf#113977) for upcoming LO 6.2.
For this specific task, =MID(A1;SEARCH("^[A-Z]*[0-9]*";A1);SEARCH("[^0-9]";A1;SEARCH("[0-9]";A1))-1) will do. But @erAck has introduced a new REGEX function (tdf#113977) for upcoming LO 6.2.