text case

[SUNIL PATEL]

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

 

[Andy Wiggins]

=PROPER()

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

 

[Myrna Larson]

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