Excel formula to split data based on specific character


=LEFT(L2,FIND("-",L2)-1)