Forums
New posts
Search forums
Members
Current visitors
Log in
Register
What's new
Search
Search
Search titles only
By:
New posts
Search forums
Menu
Log in
Register
Install the app
Install
Forums
Archive
Newsgroup Archive
Office For Mac
Mac Office Excel
Converting to PROPER text?
JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
Reply to thread
Message
[QUOTE="Peo Sjoblom, post: 6790332"] You can do that by using a macro press Opt + F11, select insert>module and paste in the below Sub PropCase() Application.DisplayAlerts = False Dim R As Range For Each R In Selection.Cells If R.HasFormula Then R.Formula = "=PROPER(" & Mid(R.Formula, 2) & ")" Else R.Value = Application.Proper(R.Value) End If Next Application.DisplayAlerts = True End Sub Select the values and run the macro [/QUOTE]
Verification
Post reply
Forums
Archive
Newsgroup Archive
Office For Mac
Mac Office Excel
Converting to PROPER text?
Top
