Just a very quick question.

I need code to determine whether a given string contains common delimiters or not. I want the output as a Select Case/End Select. (i.e. first case = if string contains any of the following delimiters. Case else = string doesn't contain).

The delimiters I want to capture are:
  • Space ( )
  • Comma (,)
  • Full stop/period (.)
  • Underscore (_)


(I won't need "-" because of the danger of picking up hyphenated surnames).

(Yes I could work this out myself but my solution would be large and messy. I am hoping for a quick compact solution here folks! )
(Background Info: I intend to implement this code into another project I am working on: http://www.excelforum.com/excel-form...ngle-word.html