Hi Ken,

The reason you are getting the error in Cell C11 for the 'blank' department is because the results of the cell in column B has no characters after the - thus null is getting returned for the function (or Error).

Thus you can do a check with an IF statement to see if - is the last character:
=IF(RIGHT($B11,1)!="-",MID($B11,FIND("-",$B11,1)+2,LENGTH($B11)),"")

This gets rid of the errors for both cells. But you'll need to come up with something for column D to print some description when the Dept code is blank:
=IF(TRIM($C11)=="*","Consolidated",IF(TRIM($C11)=="`",TRIM(DEPARTMENT(1)),IF($C11=="","Desc",PROPER(ADGET("gldept.desc",$C11)))))

Of course, replace "Desc" with what you want.