Move text (the word "The") to beginning of cell

I have a few thousand rows of text all in 1 column that all start and end with different words but some have the word "The" at the end after a comma. I need a way to move "The" to the beginning of the cell in front of the rest of the text.

Example - I need to turn this:
Test
Something
Problem, The
Anything
Something else
Macro, The

Into This:
Test
Something
The Problem
Anything
Something else
The Macro

Any thoughts on how this can be done? I thought about using text to columns and using a comma as the deliminator however several cells throughout the document have commas in them and I don't want that text moved to a new column - only the cells with ,The at the end.

Thanks!

Use a helper column with:

Please Login or Register  to view this content.