Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Change case of text
Is there a 'change case' shortcut found in Excel, similar to the one found in
Office Word - under format? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Change case of text
No, that is a word-processor function. In Excel you would have to create it.
I have a UDF that does sentence case. I am sure it could easily be adapted to act like Word's F3 Public Function SentenceCase(ByVal para As String) As String Dim oRegExp As Object Dim oMatch As Object Dim oMatches As Object para = LCase(para) Set oRegExp = CreateObject("VBScript.RegExp") oRegExp.Pattern = "^[a-z]|\.( )*[a-z]" oRegExp.Global = True Set oMatches = oRegExp.Execute(para) For Each oMatch In oMatches With oMatch Mid(para, .FirstIndex + 1 + .Length - 1, 1) = _ UCase(Mid(para, .FirstIndex + 1 + .Length - 1, 1)) End With Next oMatch SentenceCase = para End Function -- HTH RP (remove nothere from the email address if mailing direct) "Ferd" wrote in message ... Is there a 'change case' shortcut found in Excel, similar to the one found in Office Word - under format? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Convert number into words | Excel Discussion (Misc queries) | |||
Convert Numeric into Text | Excel Worksheet Functions | |||
Identifying the Active Fill Color | Excel Discussion (Misc queries) | |||
change typed text to upper case | Excel Discussion (Misc queries) | |||
How do I change existing text from lower case to upper case | Excel Discussion (Misc queries) |