Hi again,

Am Sun, 12 Apr 2020 19:12:27 +0200 schrieb Claus Busch:

=MID(A1&", "&A1,FIND(" ",A1&", "&A1)+1,LEN(A1)+1)

to change only the titles with THE, A and An at the start, try:
=IF(OR(LEFT(A1,FIND(" ",A1)-1)={"The";"A";"An"}),MID(A1&", "&A1,FIND(" ",A1&", "&A1)+1,LEN(A1)+1),A1)


Regards
Claus B.
--
Windows10
Office 2016