Use this for the first then

=IF(ISNUMBER(FIND(" ",A11,FIND(",",A11)+2)),LEFT(A11,FIND("
",A11,FIND(",",A11)+2)),A11)

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"kswan" wrote in message
...
Thanks Bob,

It works for all cases where there is a middle initial at the end of the
name but in some cases there is no middle initial just the name.

What happens when I apply the formula below I get #value for those people
who have no middle initial

Any advise.
Thanks again

"Bob Phillips" wrote:

If it is always that format

=LEFT(A11,FIND(" ",A11,FIND(",",A11)+2))

=SUBSTITUTE(A11,B11,"")

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my
addy)

"kswan" wrote in message
...
I have browsed the questions to remove the middle initial from the name
cell
and see the response if the middle initial is in the middle of the name
in
one cell.

The problem I have is the middle initial is at the end of the names.

eg Smith, John J.
I need to have Smith, John in one cell and remove the J. In some cases
there
may be a J. Jr.

Any help would be appreciated
Kathy