Hi Andy

Thanks for your help.

I have also just come across another way to do this too.... using the
PROPER() function.

Cheers
:)


--
fuzzyjon
------------------------------------------------------------------------
fuzzyjon's Profile: http://www.excelforum.com/member.php...o&userid=34378
View this thread: http://www.excelforum.com/showthread...hreadid=542110