First Initial & Last Name?

[mycon73]

Hi,

I have a single cell with a first & last name. I would like to extract the first initial & last name out of it.

For example:

MyCon Nguyen M. Nguyen
Cell: D7

Right now I have the function which gives me the initials:

=LEFT(D7,1)&"."&MID(D7,(FIND(" ",D7)+1),1)&"."

Now, I'm seeking to keep the last name, but extract out first initial. Perhaps, in the even that team members has same initials, I may need a middle initial.


Please advise....

Thanks