Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
putting a column of names into alphabetical order | Excel Discussion (Misc queries) | |||
organize a list of names in alphabetical order | Excel Discussion (Misc queries) | |||
Highest then alphabetical order By Names? | Excel Discussion (Misc queries) | |||
sort last names by in alphabetical order | Excel Discussion (Misc queries) | |||
Formula to sort names in alphabetical order? | Excel Discussion (Misc queries) |