#HOW TO REMOVE CERTAIN EXCEL SYMBOLS SERIES#

It also faster than comparing two lists together. This solution has the advantage to be functionnal even if the user finds a way to introduce new special characters. The Wikipedia list of Unicode characers is a good quick-start if you want to customize this function a little more. Output = output & ' ' 'add the replacement character (space) to your output Output = output & c 'add the character to your output. If (c >= 'a' And c = '0' And c = 'A' And c <= 'Z') Then This is the vba code: Function cleanString(text As String) As StringДim c 'since char type does not exist in vba, we have to use variant type.Д¬ = Mid(text, i, 1) 'Select the character at the i position In the case that you not only want to exclude a list of special characters, but to exclude all characters that are not letters or numbers, I would suggest that you use a char type comparison approach.ДЇor each character in the String, I would check if the unicode character is between 'A' and 'Z', between 'a' and 'z' or between '0' and '9'. NewString = Replace(newString, char, ' ') Const SpecialCharacters As String = 'modify as neededДЇor each char in Split(SpecialCharacters, ',') If you have a lot of potential special characters (non-English accented ascii for example?) you can do a custom function or iteration over an array. 'newString = replace(newString, '!', ' ') '# OR, if it is easier for you to interpret, you can do two sequential statements:

#HOW TO REMOVE CERTAIN EXCEL SYMBOLS SERIES#

If you have several characters, you can do this in a custom function or a simple chained series of Replace functions, etc.

What do you consider 'special' characters, just simple punctuation? You should be able to use the Replace function: Replace('p.k','.',' ').

How to remove certain excel symbols