text case
 

I know about UCASE and LCASE, but can you format the text "PLEASE HELP" to
"Please Help" or even to "Please help" using code.

Sunil

text case
 

=PROPER()

--
Regards
Andy Wiggins
www.BygSoftware.com
Home of "Save and BackUp",
"The Excel Auditor" and "Byg Tools for VBA"



"SUNIL PATEL" wrote in message
...
I know about UCASE and LCASE, but can you format the text "PLEASE HELP" to
"Please Help" or even to "Please help" using code.

Sunil

text case
 

Sub Test()
sText = "PLEASE HELP"
sText2 = Application.Proper(sText) 'Please Help
sText3 = UCase$(Left$(sText, 1)) & LCase$(Mid$(sText, 2)) 'Please help
Debug.Print sText, sText2, sText3
End Sub

On Thu, 8 Jul 2004 11:24:26 +0100, "SUNIL PATEL"
wrote:

I know about UCASE and LCASE, but can you format the text "PLEASE HELP" to
"Please Help" or even to "Please help" using code.

Sunil