I found out my boss has been wasting hours of time to retype a bunch of titles in title case. I think we can export the original list to Excel, use the PROPER formula to capitalize the first letter of all words, and then use Find & Replace on a list of strings like " The " to " the ". The biggest issue with this I can think of would be that the same "the" would be lowercase after a colon when it should be capitalized in those instances.

When I try searching it I just find information about proper case, which isn't the same though it's being equated. Surely there's a better way than what I came up with, or something that can deal with the colon case in particular. If it comes down to it, searching for colons after doing the other changes and manually fixing things would still be many hours and a pair of exhausted hands saved.

I took several online programming classes a few years ago that included reading data from files, manipulating it, then writing to Excel documents, so I could probably refresh my knowledge and put something together that would eliminate the Find & Replace step, but an Excel solution would be easier to implement immediately and perfect if there is some kind of formula I can download that does this without me having to reinvent something in a worse way. I don't know that much about what I can do in Excel and mainly use it to categorize items in lists.

By title case, I am referring to proper capitalization in used in titles, such as for books, movies, etc.

Does anyone have any ideas to improve upon my idea? I don't want to present a subpar solution if there's something that will do more of what we want automatically.