Capitalization
Is there away to change a fully capitalized word into a properly formatted
word? Example: EXCEL changed to Excel. |
Capitalization
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. |
Capitalization
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. |
Capitalization
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. |
Capitalization
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. |
Capitalization
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. |
Capitalization
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. |
Capitalization
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. |
All times are GMT +1. The time now is 04:39 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com