Hi,

Am Sun, 12 Apr 2020 05:28:39 -0700 (PDT) schrieb
:

I can't work out how to make this work. I to am using Excel. Can you break down the actual actions so I can follow them. I have a list of almost 900 that I need to alphabeticalize and want to move the THE, A & AN to the end of the title - as in: Bible, The

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

if it doesn't work provide some examples


Regards
Claus B.
--
Windows10
Office 2016