Hi, Dave.
Sorry! I made a mistake. The format of the name is Lastname, FirstName X
where X=middle initial. I mistakenly put a comma after Firstname. I tried
modifying your formula, but it doesn't seem to be working for me. =) Can
you help?
Thanks!
"Dave Peterson" wrote:
> I'd use a helper cell:
>
> =IF(MID(A1,LEN(A1)-2,2)=", ",LEFT(A1,LEN(A1)-3),A1)
>
> And drag down the column.
>
> mira wrote:
> >
> > Hello.
> >
> > I need a function that strips the Middle Initial of a name. The names on my
> > spreadsheet are all mixed up with names that have middle initials, and some
> > that done. For example, I would like to strip the middle initial, 'X' off
> > this name, "Doe, John, X", where Doe=last name, John=First Name, X=Middle
> > Initial
> >
> > Hope that makes sense.
> >
> > Thanks!
>
> --
>
> Dave Peterson
>
Bookmarks