Hello,
I would like a formula solution to splitting a text prefix from a combination of text and numbers that make up a product's item number. Typical examples:
ACAN SIVV08
EUON LIM18-2
<tbody>
SYRI JOS18-st
</tbody>
TAXU FAS50D
There are two consistent features in all the item numbers...