can i rearrange names in alphabetic order
 

Hello friends.. i have the following data in excel ....

A1 = Aslam Khan
A2 = Zubair Ali
A3 = Bazid Khan
A4 = Nauman Khan
..................
...............
i have approximately 500 names in columns.. and i want to rearrange
them in alphabetic order is there is any formula or way to do this

thanks.


--
naughtyboy
------------------------------------------------------------------------
naughtyboy's Profile: http://www.excelforum.com/member.php...o&userid=37151
View this thread: http://www.excelforum.com/showthread...hreadid=568932

can i rearrange names in alphabetic order
 

Hi,

Select the data ,goto menu Data-Sort

Thanks
Xcelion



"naughtyboy" wrote:


Hello friends.. i have the following data in excel ....

A1 = Aslam Khan
A2 = Zubair Ali
A3 = Bazid Khan
A4 = Nauman Khan
..................
...............
i have approximately 500 names in columns.. and i want to rearrange
them in alphabetic order is there is any formula or way to do this

thanks.


--
naughtyboy
------------------------------------------------------------------------
naughtyboy's Profile: http://www.excelforum.com/member.php...o&userid=37151
View this thread: http://www.excelforum.com/showthread...hreadid=568932