This macro changes the case of all text notes and leaders in the current Revit model. You can convert to UPPERCASE, lower case, and Title Case (the first letter of each word gets capitalized). The macro file contains three macros:
To run the macro, first load the macro RVT file. Make the file containing the text you want to change the active file in Revit. Go to Manage > Macro Manager to open the Revit Macro Manager. Select the macro you want to run from the list then click the "OK" button to run it. The macro will update the text and alert you when it's complete.
Macro files are included for Revit 2014, 2015, and 2016.
To download the free Change Text Case macro, which is part of the ArchSmarter Toolbox, subscribe to ArchSmarter email updates.