First Initial & Last Name?

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

Hi

Have you tried Data Tab, text to columns to sort your data first before using formula.

Chris

Hi Ace_XL

This works great!!!

I knew there was something out there....

Thanks

try..

=LEFT(D7,1)&"."&TRIM(RIGHT(SUBSTITUTE(D7," ",REPT(" ",100),LEN(D7)-LEN(SUBSTITUTE(D7," ",""))),100))

Hi,

I have a dynamic spreadsheet, which will change frequently.

I saw a function here a while ago that I think was similar to mine, but can't seem to find at the moment.

Thanks

I knew there was something out there....

There always is..seek and thou shall find!