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.

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

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

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.