View Single Post
  #11   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default Excell 2007: How to arrange cells in a column file alphabetica

NOT! NOT!

Thanks for picking that up Jerry

Gord

On Thu, 4 Dec 2008 16:30:05 -0800, JLatham <HelpFrom @
Jlathamsite.com.(removethis) wrote:

I think Gord left out a small word ... "not" between "I would recommend you
do" and "use event code..." as that would seem to go along with the rest of
his logic, which I tend to agree with - especially if the list is long at all.

"Gord Dibben" wrote:

I would recommend you do use event code to sort automatically as you enter
names.

Very difficult to track any errors in input once the sort has taken place.

Make sure the name and info is correct then sort manually as others have
posted.


Gord Dibben MS Excel MVP

On Thu, 4 Dec 2008 12:52:01 -0800, Vince
wrote:

How can I arrange the data straight down in a column arrange alphabetically??
For instance I enter the name of all my business contacts in a cell, how
could I make it so that every time I enter a new name, it will file it
alphabetically? Thanks much