View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Dave B[_9_] Dave B[_9_] is offline
external usenet poster
 
Posts: 22
Default search within string

I'd like to see if a cell contains only "-" and " " (space) characters.
So I'd like to identify " -----" or " - - - - ", but not " --a- ".
I figure I could look one character at a time for something other than
" " or "-". But this seems tedious. Is there an easier way? Thanks.