Forum     

Go Back   Digit Technology Discussion Forum > Portables, Peripherals and Electronics > QnA (read only)
Register FAQ Calendar Mark Forums Read

QnA (read only) Mods please help transfer the contents of this forum to proper sections. :)


 
 
LinkBack Thread Tools Search this Thread Display Modes
Old 11-02-2007, 01:39 PM   #1 (permalink)
Alive Again...
 
satyamy's Avatar
 
Join Date: May 2005
Location: Mumbai
Posts: 1,668
Question How to arrange name in alphabetic order


I have a very large number of name address & phone number in an excel sheet
I need to take a printout of it so that i can send invitations
the quantity is too large that i cant arrange it manually
I want to arrange all the names in alphabetic order
because their are many name which have appeared their 5-6 times so i want to arrange it & remove the repeated names
is their any formula in excel so that it arranged in alphatical order automatically
or any other software available
Pls help.........
satyamy is offline  
Advertisements. Register and be a member of the community to get rid of them.
Advertisement

Old 11-02-2007, 01:49 PM   #2 (permalink)
Google Bot
 
Pathik's Avatar
 
Join Date: Aug 2005
Posts: 9,772
Default Re: How to arrange name in alphabetic order

select the rows and click the A-Z (sort ascending) button... on the taskbar just below the help text
Pathik is offline  
Old 11-02-2007, 01:50 PM   #3 (permalink)
Human Spambot
 
Arsenal_Gunners's Avatar
 
Join Date: May 2005
Posts: 3,116
Default Re: How to arrange name in alphabetic order

Yeah dude,select the column containing names by clicking on its header(A,B,C etc.) and press the sorting option,it is like A downarrow
Z
(Cant tell the exact location because I am using office 2007)But sort should be in edit menu.
Arsenal_Gunners is online now  
Old 11-02-2007, 01:55 PM   #4 (permalink)
Google Bot
 
Pathik's Avatar
 
Join Date: Aug 2005
Posts: 9,772
Default Re: How to arrange name in alphabetic order

reps welcome
Pathik is offline  
Old 11-02-2007, 01:56 PM   #5 (permalink)
Human Spambot
 
Arsenal_Gunners's Avatar
 
Join Date: May 2005
Posts: 3,116
Default Re: How to arrange name in alphabetic order

^^Can't rep you(repped you sometime ago)
Arsenal_Gunners is online now  
Old 11-02-2007, 03:40 PM   #6 (permalink)
Alive Again...
 
satyamy's Avatar
 
Join Date: May 2005
Location: Mumbai
Posts: 1,668
Default Re: How to arrange name in alphabetic order

Quote:
Originally Posted by pathiks
select the rows and click the A-Z (sort ascending) button... on the taskbar just below the help text
superb answerman
thanks for this great help
i'll rep u sure
__________
any other way which can find out double & repeated names..........?

Last edited by satyamy; 11-02-2007 at 03:40 PM. Reason: Automerged Doublepost
satyamy is offline  
Old 11-02-2007, 03:49 PM   #7 (permalink)
Google Bot
 
Pathik's Avatar
 
Join Date: Aug 2005
Posts: 9,772
Default Re: How to arrange name in alphabetic order

well u can try edit>find and replace ...
find the particular text and replace all duplicates wit a space or blank text...
Pathik is offline  
 

Bookmarks

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


 
Latest Threads
- by clinton
- by Charan
- by Krow

Advertisement




All times are GMT +5.5. The time now is 11:55 PM.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2012, vBulletin Solutions, Inc.

Search Engine Optimization by vBSEO 3.3.2