Can you help me correct this formula.

=IF(New_Table!D2=TRIM(SUBSTITUTE(A1,MID(A1,MIN(FIN D({0,1,2,3,4,5,6,7,8,9},A1&"0123456789")),SUM(LEN( A1)-LEN(SUBSTITUTE(A1,{0,1,2,3,4,5,6,7,8,9},"")))),"") )"LT","Part
Time, or Temp
Student",IF(New_Table!D2="DLT"=TRIM(SUBSTITUTE(A1, MID(A1,MIN(FIND({0,1,2,3,4,5,6,7,8,9},A1&"01234567 89")),SUM(LEN(A1)-LEN(SUBSTITUTE(A1,{0,1,2,3,4,5,6,7,8,9},"")))),"") ),"Part-Time or Temp Student","Regular Full Time Student"))

Assume the contents of Column A1 has a 2 - 3 character letter code along
with a 4 digit number. The trim function works correctly to get rid of the
number and leaves only the letters. I then need to combine with an if
statement to get the results I need posted in the correct column.