I'd appreciate if you can give me an idea of how to do the following. I have a column that has all its cells filled with text. I whould like to create another column with exactly the same text as the original column but with the addition of using the worksheet function PROPER. I then want all the changes made by the proper function to show in the original column using vba. any idea? please help.
If your text is in Column A then in Row 1, say Column D...
Code:
=PROPER(A1)
Then Copy Column D and Paste Special/Values in Column A.
Or a VBA solution (select a cell in the column where your text is and run this)...
Code:
Sub MakeProper()
With Selection
Row1 = .CurrentRegion.Row
Row2 = .CurrentRegion.Rows.Count + Row1 - 1
col = .Column
End With
For Each r In Range(Cells(Row1, col), Cells(Row2, col))
r.Value = Application.Proper(r.Value)
Next
End Sub
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.