Hello, thank you for your reply.

below is a screen print on what i am trying to do, this should make it
more easy to uderstand... :)

[image: http://img.photobucket.com/albums/v6...r/STUDENT.jpg]

in Cell C16 i want to be able to put in a formula which will take the
first 3 letters in Cell B16 than add those numbers like in C20 and C21,
those are examples i made to show you what i mean.

thank you for your help.... :)


--
Maltenrazer
------------------------------------------------------------------------
Maltenrazer's Profile: http://www.excelforum.com/member.php...o&userid=16130
View this thread: http://www.excelforum.com/showthread...hreadid=275688