Help! Need Excel2007Macro to create text value

I am in the urgent need for a Ecel 2007 Macro that can identify the first character in cells from Column X, then place a text value in Column AC, same Row.
Example1; if first character in Cell X:10 is B then enter the word Student in Cell AC:10.
Example2; if first character in Cell X:11 is M then enter the word Master in Cell AC:11.

Please Help, Urgent.

It's not a macro, it's a formula. Put this in cell AC:10

=IF(OR(LEFT(X10;1)="b";LEFT(X10;1)="B");"Student";IF(OR(LEFT(X10;1)="m";LEFT(X10;1)="m");"Master";""))

and it will do the job
attn: you might have another separator for functions variables instead of ";" use the one from your computer

Thank you very much for your help. But still, I may be doing something wrong.

My excel is 2007 and that might be the reason for not working.
Could you please verify in real time, if it will work as provided in Excel 2007.