Pulling the last name and first initial from a full name

[mabelline]

I am trying to convert hundreds of names from a full name to the last name plus first initial.

IE: John D. Doe to doej

Here are some examples: Some have middle initials and some don't

George T. Jones = jonesg
John D. Doe = doej
Alan Johnson = johnsona
Roger Doe = doer

 

[Scott Huish]

=LOWER(TRIM(RIGHT(SUBSTITUTE(A1," ",REPT(" ",255)),255))&LEFT(A1))

Excel Workbook
	A	B
1	George T. Jones	jonesg
2	John D. Doe	doej
3	Alan Johnson	johnsona
4	Roger Doe	doer
Sheet1