Ask Your Question

Revision history [back]

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.