Uppercase

  • Thread starter Thread starter SteveG
  • Start date Start date
S

SteveG

I have a spreadsheet with hundreds of names on it. The
first letter of all names is in upper case and the rest
lower. I would like to put all letters in names in upper
case without having to do them all individually.
can anyone help.
Thanks
 
With your data in A1:A1000, in B1 put =UPPER(A1) and copy down. Select B1:B1000
and copy and paste special as values. Then delete Col A.
 
Hi Steve

See this webpages
http://www.mvps.org/dmcritchie/excel/proper.htm
Or
http://www.cpearson.com/excel/case.htm

Here is a macro for changing the cells with text in the selection

Sub Uppercase_macro()
Dim selectie As Range
Dim cel As Range
On Error Resume Next
Set selectie = Range(ActiveCell.Address & "," & Selection.Address) _
.SpecialCells(xlCellTypeConstants, xlTextValues)
If selectie Is Nothing Then Exit Sub
Application.ScreenUpdating = False
Application.Calculation = xlCalculationManual
For Each cel In selectie
cel.Value = UCase(cel.Value)
Next cel
Application.ScreenUpdating = True
Application.Calculation = xlCalculationAutomatic
End Sub
 
Back
Top