Use regular expressions to find the first digit, then return the input string from the first character until the character before the first digit using this expression:

`left (INPUT,regexp_match( INPUT,'\\d')-1)`

[![enter image description here][1]][1]


  [1]: https://i.sstatic.net/BIyWo.png