How do I capilize a list of names on excel?
 

i've made a really long list of names (first and last) in two columns in
excel and would like to know if there's a way of capitalizing them without
going through them one by one.

trivial i know but would be greatly appreciated.

=upper(a1)
on cell c1
=upper (b1) on cell d1
for your first and last names
Now copy c1 and d1 and paste it all the way down.

Then select column C and D and copy edit paste special values to lose the
formulas.





"vrajna" wrote in message
...
i've made a really long list of names (first and last) in two columns in
excel and would like to know if there's a way of capitalizing them without
going through them one by one.

trivial i know but would be greatly appreciated.

In B1: =PROPER(A1)

copy down

--

HTH

RP
(remove nothere from the email address if mailing direct)


"vrajna" wrote in message
...
i've made a really long list of names (first and last) in two columns in
excel and would like to know if there's a way of capitalizing them without
going through them one by one.

trivial i know but would be greatly appreciated.

check out the PROPER() function

You may find this macro useful.
Sub ChangeCase()
Application.ScreenUpdating = False
Dim r As Range
nCase = UCase(InputBox("Enter U for UPPER" & Chr$(13) & " L for
lower" & Chr$(13) & " Or " & Chr$(13) & " P for Proper", "Select
Case Desired"))
Select Case nCase
Case "L"
For Each r In Selection.Cells
If r.HasFormula Then
r.Formula = LCase(r.Formula)
'R.Formula = R.Value
Else
r.Value = LCase(r.Value)
End If
Next

Case "U"
For Each r In Selection.Cells
If r.HasFormula Then
r.Formula = UCase(r.Formula)
'R.Formula = R.Value
Else
r.Value = UCase(r.Value)
End If
Next
Case "P"

For Each r In Selection.Cells
If r.HasFormula Then
r.Formula = Application.Proper(r.Formula)
'R.Formula = R.Value
Else
r.Value = StrConv(r.Value, vbProperCase)
End If
Next
End Select
Application.ScreenUpdating = True
End Sub

--
Don Guillett
SalesAid Software

"vrajna" wrote in message
...
i've made a really long list of names (first and last) in two columns in
excel and would like to know if there's a way of capitalizing them without
going through them one by one.

trivial i know but would be greatly appreciated.