how to make proper work in excel worksheet

[Guest]

I can not make "Proper or Upper work in my excel worksheet

 

[Myrna Larson]

These are functions, of course. They don't change data in-place.

In another column, you write a formula like =PROPER(A1) or =UPPER(A1)

Is that what you are doing? If so, what does the original cell show, and what
is the formula result?

 

[Guest]

Myrna, this did work, thank you, but is there anyway to change proper data
in-place?

 

[Jerry W. Lewis]

You could write a VBA macro to do it.

Jerry

Myrna, this did work, thank you, but is there anyway to change proper data
in-place?

:

 

[Gord Dibben]

Such a macro could be..........

Sub zzProper_Case()
Dim Cell As Range
Dim selected As Range
On Error Resume Next
Set selected = Range(ActiveCell.Address & "," & Selection.Address) _
.SpecialCells(xlCellTypeConstants, xlTextValues)
If selected Is Nothing Then Exit Sub
For Each Cell In selected
Cell.Formula = Application.Proper(Cell.Formula)
Next
End Sub

Select your range of data and run the macro.

If not familiar with VBA and macros, see David McRitchie's site for more on
"getting started".

http://www.mvps.org/dmcritchie/excel/getstarted.htm

In the meantime..........

To create a General Module, hit ALT + F11 to open the Visual Basic Editor.

Hit CRTL + R to open Project Explorer.

Find your workbook/project and select it.

Right-click and Insert>Module. Paste the above code in there. Save the
workbook and hit ALT + Q to return to your workbook.

Run the macro by going to Tool>Macro>Macros.

Gord Dibben Excel MVP