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

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" wrote:

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

Try

=PROPER(A1)

With your text string in a1

Mike

"AMezera" wrote:

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

Is there a way to do it without a formula?

"Luke M" wrote:

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" wrote:

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

Is there a way to do this without a formula?

"AMezera" wrote:

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

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.
--
Best Regards,

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


"AMezera" wrote:

Is there a way to do it without a formula?

"Luke M" wrote:

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" wrote:

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

the formula you both suggested worked. Thank you both.

"AMezera" wrote:

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

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

On Wed, 24 Jun 2009 13:03:01 -0700, AMezera
wrote:

Is there a way to do this without a formula?

"AMezera" wrote:

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