Remove Non-AlphaNumeric Characters from String

The function below will allow us to remove a non alphanumeric character from an input string.

Be careful though, lengther the string, more time needed to evaluate each string on the sentence.

To bad that I don’t have any idea on how to use Regular Expression in Excel VBA, if we can use regex to replace all the unwanted character directly, it would be great

Function GETALPHANUMERIC(text)

str_all = "abcdefghijklmnopqrstuvwxyz1234567890"
For lenstr = 1 To Len(text)
    If InStr(str_all, LCase(Mid(text, lenstr, 1))) Then
        GETALPHANUMERIC = GETALPHANUMERIC & Mid(text, lenstr, 1)
    End If
Next

End Function

If somehow what we need is only the apha part without the numeric part or vice versa, simply adjusting the value of str_all variable will solve it.

Posts Related to Remove Non-AlphaNumeric Characters from String

How to get an Acronym using Excel VBA?
The purpose of the following example of Excel VBA macro is to get the acronym or an abbreviation of each of the first letter of ...
Convert Excel Column Number into Column Name
Update: Sorter version of the VBA function: Function Number2Char(c As Integer) As String Number2Char = Split(Cells(1, c).Address, "$")(1) End Function Courtesy of The Plaid Cow. ...
Check If Excel Workbook is Already Open or Not
In my case, I work a lot with transferring data from current Excel Workbook to another Excel Workbook, and to be able to do that, ...
Excel VBA Add Set of Worksheets Automatically
There is a time when we must create a set of Excel Worksheets templates on a regular basis in our work. For example, a set ...
How to Get a Full File Path in Excel?
Ever needed to find out the full path of your current file? What I mean by full path here is the full location of the ...

911 Responses to Remove Non-AlphaNumeric Characters from String

Pingback: company web site
Pingback: norcross tree removal
Pingback: body repair
Pingback: purchase payday loan online
Pingback: mansfield montessori academy
Pingback: diabetic bags
Pingback: view site
Pingback: www.easyloanfast.com
Pingback: business coaches brisbane
Pingback: california workers comp insurance rates
Pingback: cordless impact wrench reviews

Remove Non-AlphaNumeric Characters from String

Posts Related to Remove Non-AlphaNumeric Characters from String

How to get an Acronym using Excel VBA?

Convert Excel Column Number into Column Name

Check If Excel Workbook is Already Open or Not

Excel VBA Add Set of Worksheets Automatically

How to Get a Full File Path in Excel?

911 Responses to Remove Non-AlphaNumeric Characters from String

Leave a Reply Cancel reply

Recent Posts