<div>
pls try 
 

<pre><code class="code-1 nolinks" id="code-20-41485414-1">Function f(myString) As String
 Dim vNums As Variant
 Dim Nm As Variant
 vNums = Array(0, 1, 2, 3, 4, 5, 6, 7, 8, 9)
 For Each num In vNums
 myString = Replace(myString, CStr(num), &quot;&quot;)
 Next
 f = myString
End Function
</code></pre>
EDIT 
 
or with regex 
 

<pre><code class="code-10 nolinks" id="code-20-41485414-2">Public Function GetNonNumericVals(strValue As Variant) As String

Dim re As Object
Set re = CreateObject(&quot;VBScript.RegExp&quot;)
With re
 .Global = True
 .IgnoreCase = True
 .Pattern = &quot;[\d]&quot;
 GetNonNumericVals = .Replace(strValue, &quot;&quot;)
End With
Set re = Nothing

End Function
</code></pre>
Regards
</div>

<div>
place this funtion in a regular module 
 

<pre><code class="code-10 nolinks" id="code-20-41485422-1">Function AlphaOnly(varString)
Dim j As Long, varStr
For j = 1 To Len(varString)
 If Not IsNumeric(Mid(varString, j, 1)) Then
 varStr = varStr &amp; Mid(varString, j, 1)
 End If
Next
AlphaOnly = varStr

End Function
</code></pre>
to use in a query 
 
select AlphaOnly([Fieldname]) from tableX
</div>

<div>
That's what happens when you stop to answer a phone call mid response.
</div>

<div>
Works perfect. 
The Like &quot;[A-Z]&quot; allows me to exclude any !@#$%^&amp;*()?&gt;&lt; characters. 
thanks
</div>

<div>
@ElCarlos, 
 
&lt;The Like &quot;[A-Z]&quot; allows me to exclude any !@#$%^&amp;*()?&gt;&lt; characters.&gt; 
 
did you try the earlier post, which will do the same?
</div>

<div>
<div class="content wysiwyg-content">
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. &nbsp;So I would like to have a function that would essentially pull out the alpha characters only. 
Example Data: 
Input &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Result 
P22758 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; P 
WR23789 &nbsp; &nbsp; &nbsp; WR 
58KLG1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;KLG 
984P8372JJ &nbsp; &nbsp;PJJ 
123K &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;K 
M &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; M
</div>
</div>

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

How To Extract only alpha characters from alpha numeric string

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.