Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I change case to sentence case in groups in excel?
How do I change case to sentence case in groups in excel? This is easily
done in Word. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I change case to sentence case in groups in excel?
Goto the following link and download ASAP Utilities, its free. http://www.asaputilities.nl/ One of the options in 'Text' in this utility is to Change case. It also has numerous other useful bits and pieces for Ecel. Enjoy -- grahammal ------------------------------------------------------------------------ grahammal's Profile: http://www.excelforum.com/member.php...o&userid=20336 View this thread: http://www.excelforum.com/showthread...hreadid=542509 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I change case to sentence case in groups in excel?
Very Helpful! Thank you very much. This will be a tremendous time saver!
"grahammal" wrote: Goto the following link and download ASAP Utilities, its free. http://www.asaputilities.nl/ One of the options in 'Text' in this utility is to Change case. It also has numerous other useful bits and pieces for Ecel. Enjoy -- grahammal ------------------------------------------------------------------------ grahammal's Profile: http://www.excelforum.com/member.php...o&userid=20336 View this thread: http://www.excelforum.com/showthread...hreadid=542509 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I change case to sentence case in groups in excel?
Copy the following macro:
Sub Change_Case() Dim ocell As Range Dim Ans As String Ans = Application.InputBox("Type in Letter" & vbCr & _ "(L)owercase, (U)ppercase, (S)entence, (T)itles ") If Ans = "" Then Exit Sub For Each ocell In Selection.SpecialCells(xlCellTypeConstants, 2) Select Case UCase(Ans) Case "L": ocell = LCase(ocell.Text) Case "U": ocell = UCase(ocell.Text) Case "S": ocell = UCase(Left(ocell.Text, 1)) & _ LCase(Right(ocell.Text, Len(ocell.Text) - 1)) Case "T": ocell = Application.WorksheetFunction.Proper(ocell.Text) End Select Next End Sub "Pinetree" wrote: How do I change case to sentence case in groups in excel? This is easily done in Word. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
count colored cells? | Excel Worksheet Functions | |||
Loop for VBA code? | Excel Worksheet Functions | |||
How can i change this VBA project According to Indian Numeric | Excel Discussion (Misc queries) | |||
Convert Numeric into Text | Excel Worksheet Functions | |||
Identifying the Active Fill Color | Excel Discussion (Misc queries) |