Thread
:
finding char within a cell
View Single Post
#
4
Harlan Grove
Posts: n/a
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)
Reply With Quote