First letter of last name

[shir02]

Hey there,

I hope you could help me

I have a list of full names (name, space, last name) that I would like to turn it to one list of names and first letter of the last name.

for instance...

From:

1. Kim Kardashian
2. Brad Pitt
3. Mila Kunis
4. Nicolas Cage
5. Miley Cyrus
6. Tom Cruise
7. Justin Timberlake
8. Elton John
9. Jamie Foxx
10. Jennifer Lopez
11. Ella Marija Lani Yelich-O'Connor
12. Pablo Diego José Francisco de Paula Juan Nepomuceno María de los Remedios Cipriano de la Santísima Trinidad Ruiz y Picasso

To:

1. Kim K.
2. Brad P.
3. Mila K.
4. Nicolas C.
5. Miley C.
6. Tom C.
7. Justin T.
8. Elton J.
9. Jamie F.
10. Jennifer L.
11. Ella M.
12. Pablo D.

Thanks in advance

[oeldere]

B15=LEFT(A15,SEARCH(" ",A15,1)+1)&"." and drag down.