PROPER

A

Annie B

I need to change the info in a column. Right now it is
all uppercase and I need for it to be like a PROPER name.
I tried the PROPER function and that is not working. I
need to do the complete column. I am a novice at excel.
Please help
 
I

icestationzbra

did you use =Proper(cell_address_of_data_which_you_want_to_change)?

if so, it should have worked fine. what is the problem that you are
facing?

here is an alternate way, it involves VBA macro.

right-click on the tab for the intended sheet, select View Code. paste
this macro in the right-pane. select all the cells for which you want
the case changed and then run this macro.

Option Explicit

Sub ProperCase()

Dim rng As Range

If Selection.Cells.Count < 2 Then Exit Sub

For Each rng In Selection

If Not IsNumeric(rng.Value) Or Not IsNumeric(Left(rng.Value, 1)) Then

rng.Value = UCase(Left(rng.Value, 1)) & LCase(Mid(rng.Value, 2,
Len(rng.Value)))

End If

Next rng

End Sub
 
Top