in Col B put this formula
=MID(A1,FIND(" ",A1)+1,1) and drag it down, you will get first
alphabet of names.
Select your range, then sort by column B


On Nov 29, 2:46*pm, abdurehmankk
wrote:
I have serial numberd list containing defferent names for example

1 adam michael
2 cristian bernad
3 xavier fernands
4 *nefeesa beegum
5 *resheeda albert
6 *baseer moosa

I wish to be the above shown names in alphabetical order