Excel 2007 : Suffix formula needed for the Jr, Sr, III in Excel 2007

Hello, I need help fixing the following code:

=IF(COUNT(SEARCH(" ",M1),SEARCH(" ", M1, SEARCH(" ",M1)+1))>1,PROPER(LEFT(M1,SEARCH(" ", M1, SEARCH(" ",M1)+1)))&PROPER(MID(M1,SEARCH(" ", M1, SEARCH(" ",M1)+1),99)),PROPER(M1))

The result of the code above gives me: Kent C & Cathy Honda Iii

I would like for it to show Kent C & Cathy Honda III

Thanks