Formula to extract First initial, Middle initial and Last name from cell

**kkal** · 03-05-2015, 02:17 PM

Hello,

I need help creating a formula that extracts a first initial, middle initial and last name from a cell. For example, If A1 contains Jane M. Doe, I'd like to populate the new cell with jmdoe.

So far I have this:

Please Login or Register  to view this content.

Which grabs the first initial and last name, but I'm having problems getting the middle initial.

Thank you!

**AlKey** · 03-05-2015, 02:27 PM

Try it like this

=PROPER(LEFT(A1)&SUBSTITUTE(TRIM(RIGHT(SUBSTITUTE(A1," ",REPT(" ",99)),99*2)),". ",""))

**kkal** · 03-05-2015, 02:30 PM

Thank you! That worked perfectly!

**AlKey** · 03-05-2015, 02:33 PM

You're welcome. Please don't forget to thank those who helped by clicking on Add Reputation * and please mark thread as "Solved" if your issue has been resolved. (Selecting Thread Tools-> Mark thread as Solved).