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!
Bookmarks