Never a bad idea to show us samples of the data you have and what you are
looking to do with them.

Are all your Column A entries **always** letters followed by numbers? If so,
you can retrieve leading letter characters using this less complicated
function call inside your IF function calls...

LEFT(A1,MIN(FIND({0,1,2,3,4,5,6,7,8,9},A1&"0123456 789"))-1)

I am not sure you will need two IF function calls to do what I think you
might be trying to do, but it would be easier to tell if you showed us some
sample data and sample output you want from them (and any code translation
that are required).

Rick


"Pat" wrote in message
...
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.