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:
Which grabs the first initial and last name, but I'm having problems getting the middle initial.![]()
=PROPER(LEFT(A1)&TRIM(RIGHT(SUBSTITUTE(A1," ",REPT(" ",99)),99)))
Thank you!
Bookmarks