Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
=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. |
#3
|
|||
|
|||
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. |
#4
|
|||
|
|||
check out the PROPER() function
|
#5
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Address List in Excel | Excel Discussion (Misc queries) | |||
create price list from excel sheet | Excel Discussion (Misc queries) | |||
how can I count distinct names in an excel list? | Excel Discussion (Misc queries) | |||
Is there a way to create a drop-down list of links in Excel? | Excel Worksheet Functions | |||
how to alphabetize a list in Excel | Excel Worksheet Functions |