Prev: Selected Nudes for Free
Next: Megastat add-in for Excel 2007
From: abdurehmankk on 29 Nov 2009 04:46
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
From: Ms-Exl-Learner on 29 Nov 2009 05:05
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!
--------------------
(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
From: muddan madhu on 29 Nov 2009 06:07
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
<abdurehma...(a)discussions.microsoft.com> 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

 | 
Pages: 1
Prev: Selected Nudes for Free
Next: Megastat add-in for Excel 2007