in vba:

StrConv(myString,vbProperCase)

in formula:

=PROPER(A2)


that help?


--
medicenpringles


------------------------------------------------------------------------
medicenpringles's Profile: http://www.excelforum.com/member.php...o&userid=16458
View this thread: http://www.excelforum.com/showthread...hreadid=492453