Avatar of ElCarlos

asked on 

How To Extract only alpha characters from alpha numeric string

I am using Access 2010 and would like a vba function to extract out the alpha characters from a mixed alpha numeric string, this string is in a table.  So I would like to have a function that would essentially pull out the alpha characters only.
Example Data:
Input              Result
P22758           P
WR23789       WR
58KLG1          KLG
984P8372JJ    PJJ
123K              K
M                   M
Microsoft Access

Avatar of undefined
Last Comment
Dale Fye

8/22/2022 - Mon