Tom Ogilvy Wrote:
If you have more than one word, the formula would be

=Ucase(Left(A1,1)) & lcase(Right(A1,len(A1)-1))


Do you want this to happen when a user enters data in that column?


NO. The text is already there.

Thanks. You've been a great help. Much appreciated!


--
Excel_help
------------------------------------------------------------------------
Excel_help's Profile: http://www.excelforum.com/member.php...o&userid=36439
View this thread: http://www.excelforum.com/showthread...hreadid=566301