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.
Pingback: Importing WordPress Users via CSV Files | Webplus - web developer resource blog
Pingback: debt consolidation companies
Pingback: debt consolidation company
Pingback: debt consolidation
Pingback: home air purifier
Pingback: wisdom teeth extraction
Pingback: pechhulp europa
Pingback: Austin Powers
Pingback: debt collection agency
Pingback: Wedding photographer services calgary
Pingback: video x
Pingback: Alternative Energy Projects