S SUNIL PATEL Jul 8, 2004 #1 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
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
A Andy Wiggins Jul 8, 2004 #2 =PROPER() -- Regards Andy Wiggins www.BygSoftware.com Home of "Save and BackUp", "The Excel Auditor" and "Byg Tools for VBA"
=PROPER() -- Regards Andy Wiggins www.BygSoftware.com Home of "Save and BackUp", "The Excel Auditor" and "Byg Tools for VBA"
M Myrna Larson Jul 8, 2004 #3 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
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
