View Single Post
  #4   Report Post  
Harlan Grove
 
Posts: n/a
Default

Domenic wrote...
Another way...

=IF(OR(ISNUMBER(SEARCH({"/","-"},A1))),LEFT(A1,MIN(SEARCH({"/","-"},
A1&"/-"))-1),A1)

....

If you're going to append "/" and "-" to A1, there's no need for the
error trap.

=LEFT(A1,MIN(FIND({"-","/"},A1&{"-","/"}))-1)