Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Proper case
Arne,
Here we go Dim i As Long For i = 1 To Cells(Rows.Count, "A").End(xlUp).Row If Cells(i, "D").Value < Application.Proper(Cells(i, "D").Value) Then Cells(i, "E").Value = "x" Cells(i, "D").Value = Application.Proper(Cells(i, "D").Value) End If Next -- HTH Bob Phillips "arne" wrote in message ... In column D ther are names and they must be in Proper Cae. I want to loop through these and 1. Set and x in a new column x if the name is not proper case 2. Then set propercase for these Ex: start teD DANA Res Ted x Dana x |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I change from upper case to proper case in excel 2002 | Excel Discussion (Misc queries) | |||
excel'03 how to convert a column from upper case to proper case | Excel Discussion (Misc queries) | |||
Excel: How do I change all upper case ss to proper case? | Excel Worksheet Functions | |||
Changing Upper case to Proper Case | Excel Worksheet Functions | |||
Proper case | Excel Programming |