See if links help with the proper function

http://www.bettersolutions.com/excel...P612022322.htm
http://www.techonthenet.com/excel/formulas/proper.php

http://office.microsoft.com/en-us/ex...625731033.aspx

Glad the code helped

VBA Noob