View Single Post
  #3   Report Post  
Ron Coderre
 
Posts: n/a
Default

Here you go:
=LEFT(A1,FIND("-",A1)-1)

Regards,
Ron