Hello forum users!

This is my second post, and the first resulted in much success, so I hope you can help me again!

I have a list of over 3000 file names, each of which are titles with one word in ALL CAPS. That word is supposed to be the 'sort word' by which the files are alphabetized. For example:

"Kendra Smith MONROE Award in Geosciences"

Is there any way to create a macro that will do two things:
(1) identify the ALL CAPS word in the string (in this case 'MONROE') and put it in the next column
(2) change 'MONROE' in the full name to Proper Case

This would save me SO much time. Any help would be hugely appreciated!

Thank you