I know this has to be a lot easier than what I'm figuring it to be but I can't seem to figure out how to modify data based on criteria (macro or conditional formating or whatever). I'm leaning towards a macro but I've never really used macros let alone built one.

My situation is this... I have a large list of movie titles (personal collection) and I've decided I want to change the title format. This list is quite large and I don't want to manually change these titles. Specifically, I want to change titles that begin with the word "The" and place this at the end of the title (ex. "Big Lebowski, The"). Any ideas on how I can get this done?