How do I capitalize everything in Excel?
Converting text from lower case or sentence case into upper case in Excel can be achieved either with a formula or with a custom VBA function.
If you’re just doing it the once, you’ll probably just use a formula (=UPPER), but if you’re doing it regularly – try creating a custom VBA function like this…