PowerQuery Extract everything before alphabet from a column

Question

What is the most effective technique to extract data from a column while I am cleaning data? I want to extract the first ALPHABET and everything before it even if none of the variables are the same length or format. For instance:

Sample Data: 12345A123; 23456B000; 45678D93

Output: 12345A; 23456B; 45678D

Answer 1

Add column, custom column, with formula:

 = Text.Range([Column1],0,Text.PositionOfAny([Column1],{"a".."z","A".."Z"})+1)