how i get defferent names in alphabetical order
 

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

how i get defferent names in alphabetical order
 

Select the data range and select DataText to ColumnsFixed WidthNextClick
where do you want to seperate the data (i.e. Near to Number) NextFinish.

Then apply the Sorting from Datasort for the names.

Remember to Click Yes, if this post helps!
--------------------
(Ms-Exl-Learner)
--------------------


"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

how i get defferent names in alphabetical order
 

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