You could have an array with all the special character in it like so:

vb Code:
  1. Dim arr(7) as String = {"!","@","#","$","%","^","&","*"}
  2.  
  3. 'Then loop through the special character array and replace the ones in the csv text with "".
  4.  
  5. For each sc as string in arr
  6.  
  7. myCSVText = myCSVText.Replace(sc,"")
  8.  
  9. Next

Justin