Excel Capital Letters

[Guest]

I have a large worksheet with many columns, however, all the data is in lower
case letters. Is there a function or a way to change all the data into
capital letters? The data is demographic info only. Thanks inadvance.

 

[Chip Pearson]

In an adjacent column, enter the formula

=UPPER(A1)

and copy down as far as you need to go. You can the copy and
paste this data over your original data if desired.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

 

[David McRitchie]

H Humbert,
I expect you want to change those areas, probably whole columns at a time,
or other regions, in place. see
http://www.mvps.org/dmcritchie/excel/proper.htm

 

[Guest]

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