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
Pingback: debt collection rate
Pingback: white label dating blueprint
Pingback: Wedding photographer services calgary
Pingback: collection agency rates
Pingback: lower blood pressure
Pingback: collection agency
Pingback: rencontre Gatineau
Pingback: collection agency newsletter
Pingback: how to lose 10 pounds
Pingback: profumi
Pingback: what is adhd
Pingback: Juegos
Pingback: Imagenes de Amistad
Pingback: wedding photographer calgary
Pingback: Decoracion interiores
Pingback: Aussie Hair Conditioner Deals
Pingback: Wedding Photographers
Pingback: Kaspersky Antivirus 2012
Pingback: Best Cashmere Wool Yarn
Pingback: buy facebook fans
Pingback: when?
Pingback: skin whitening
Pingback: Tucson Realtors
Pingback: Buy High PR Backlinks