how i get defferent names in alphabetical order

A

abdurehmankk

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
 
M

Ms-Exl-Learner

Select the data range and select Data>Text to Columns>Fixed Width>Next>Click
where do you want to seperate the data (i.e. Near to Number) >Next>Finish.

Then apply the Sorting from Data>>sort for the names.

Remember to Click Yes, if this post helps!
 
M

muddan madhu

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to sort names in alphabetical ascending order? 7
How do I set a column in alphabetic order? 1
how do I control the sort order of a filter in a pivot table? 1
arrange list of names in alphabetical order 1
How do I put things in alphabetical order in microsoft word? 1
how do i arrange list of names alphabetically in excel? 2
how do i arrange list in alphabetical order? 1
organizing names in alphabetical order 9

Top