How to exclude anything that follows the last hyphen that starts with Text (A-Z)

[SublimizeD]

Hey all! I'm new here. I'm having some trouble with my formula. Im trying to get rid of everything after the last hyphen in the respective cells. here is what i have so far.

=IF(LEN([@[column1]])<=10|[@[column2]]|IF(RIGHT([@[column1]]|1)="-"|LEFT([@[column1]]|LEN(SUBSTITUTE([@[Andrew''s Column]]|TRIM(LEFT(RIGHT(SUBSTITUTE([@[Andrew''s Column]]|"-"|REPT(" "|100))|100)|100))|""))-1)|LEFT([@[column1]]|LEN(SUBSTITUTE([@[Andrew''s Column]]|TRIM(LEFT(RIGHT(SUBSTITUTE([@[column2]]|"-"|REPT(" "|100))|100)|100))|""))-2)))

column1 is =SUBSTITUTE([@[Andrew''s Column]]|TRIM(LEFT(RIGHT(SUBSTITUTE([@[Andrew''s Column]]|"-"|REPT(" "|100))|100)|100))|"")

column2 is the original

=IF(ISNUMBER(VALUE(RIGHT([@[Primary Facility]]|1)))|LEFT([@[Primary Facility]]|FIND("-"|[@[Primary Facility]]|1)-1)|[@[Primary Facility]])

Im attempting to exempt the cells with a-z that follow the hyphen. Any help would be appreciated.

 

[SublimizeD]

Hey all! I'm new here. I'm having some trouble with my formula. Im trying to get rid of everything after the last hyphen in the respective cells. here is what i have so far.

=IF(LEN([@[column1]])<=10|[@[column2]]|IF(RIGHT([@[column1]]|1)="-"|LEFT([@[column1]]|LEN(SUBSTITUTE([@[Andrew''s Column]]|TRIM(LEFT(RIGHT(SUBSTITUTE([@[Andrew''s Column]]|"-"|REPT(" "|100))|100)|100))|""))-1)|LEFT([@[column1]]|LEN(SUBSTITUTE([@[Andrew''s Column]]|TRIM(LEFT(RIGHT(SUBSTITUTE([@[column2]]|"-"|REPT(" "|100))|100)|100))|""))-2)))

column1 is =SUBSTITUTE([@[column2]]|TRIM(LEFT(RIGHT(SUBSTITUTE([@[column2]]|"-"|REPT(" "|100))|100)|100))|"")

column2 is the original

=IF(ISNUMBER(VALUE(RIGHT([@[original]))|LEFT([@original]]|FIND("-"|[@[original]]|1)-1)|[@[original]])

Im attempting to exempt the cells with a-z that follow the hyphen. Any help would be appreciated.