| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Changing multiple cell text from lower case to upper case | Excel Discussion (Misc queries) | |||
| vlookup -- Upper case and Lower case text | Excel Discussion (Misc queries) | |||
| Upper case text | Excel Worksheet Functions | |||
| Change the text from lower case to upper case in an Excel work boo | Excel Discussion (Misc queries) | |||
| How do I change existing text from lower case to upper case | Excel Discussion (Misc queries) | |||
Linear Mode
