Capitalization

[AMezera]

Is there away to change a fully capitalized word into a properly formatted
word?
Example: EXCEL changed to Excel.

 

[Luke M]

Ironically, the function your looking for is PROPER
=PROPER(EXCEL)
returns "Excel"

 

[Mike H]

Try

=PROPER(A1)

With your text string in a1

Mike

 

[AMezera]

Is there a way to do it without a formula?

Ironically, the function your looking for is PROPER
=PROPER(EXCEL)
returns "Excel"
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*

 

[AMezera]

Is there a way to do this without a formula?

 

[Luke M]

No. But may I ask why you're avoiding a formula? You could create the
formula(s), then do a Copy-Paste Special-Values only if you really want
static values.

 

[AMezera]

the formula you both suggested worked. Thank you both.

 

[Gord Dibben]

You could do it in place with a macro and not bother with formulas or helper
cells.

Sub Proper()
Dim Cell As Range
Application.ScreenUpdating = False
For Each Cell In Selection
Cell.Formula = Application.Proper(Cell.Formula)
Next
Application.ScreenUpdating = True
End Sub


Gord Dibben MS Excel MVP