View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Knox Knox is offline
external usenet poster
 
Posts: 45
Default select fields with more then one dash (-)

I have 40,000 records and need to delete the ones that contain more then one
dash. For example:
1 k-90
2 k-90-1
3 k-50
4 k-50-1
5 k-50-1-a

I need to select fields 2,4, and 5 so I can get rid of them

Any advice on how to do this? thank you!