Hi,

See if this does what you need:

=LEFT(A1,MIN(FIND(".",A1),FIND("-",A1),FIND("/",A1))-1)