Try

=IF(RIGHT(A1,5)=", The",RIGHT(A1,3)&" "&LEFT(A1,LEN(A1)-5),A1)


Hope it helps.


Graham Feeley Wrote:
Hi Could use some help here please have a movie list
someone sent to me and it has cells like
Age of Innocence, The
Bone Snatcher, The
Etc Etc
I would like to do a Next procedure and Replace the text
, The
and put the The in Front of the text
So it is like this
The Age Of Innocence
The Bone Snatcher
Etc Etc
Hope someone can be kind enough to help me
Regards
Graham


--
Morrigan
------------------------------------------------------------------------
Morrigan's Profile: http://www.excelforum.com/member.php...fo&userid=7094
View this thread: http://www.excelforum.com/showthread...hreadid=393313