If I have a spreadsheet with company names, is there a way to have them
alphabetize themselves?

You could use the Sort facility. Check out "Sort a List" in the help file

"Gardien" wrote:

If I have a spreadsheet with company names, is there a way to have them
alphabetize themselves?

"Gardien" wrote in message
...
If I have a spreadsheet with company names, is there a way to have them
alphabetize themselves?

How often does the list change and need to be sorted?

"Gardien" wrote:

If I have a spreadsheet with company names, is there a way to have them
alphabetize themselves?

Hello, KB!
You wrote on Sun, 15 Oct 2006 07:10:02 -0700:


K "Gardien" wrote:

?? If I have a spreadsheet with company names, is there a way
?? to have them alphabetize themselves?

I suppose you could record a macro but sorting does not take
much time, especially if you have buttons for up and down
sorting.

James Silverton
Potomac, Maryland

E-mail, with obvious alterations:
not.jim.silverton.at.comcast.not

Yes and no!

If you want to alphabetize on a "straight through" basis (regardless of
significant element) sort the company name field as is.

However, the significant part of a company name may be at the beginning or
part way through. Just consider the variation between Bill Ridgeway Co,
Ridgeway Co and Computer Solutions Co. You need to particularly clever when
it comes to some names though. Consider 'Clarke Brother & Sons'. If the
principals are 'Clarke' and 'Brother' the significant element is Clarke.
However, if the single principal is 'Clarke Brother' the significant element
is Brother. There are many variations on this theme.

If you have a helper column which contains the significant part of the name
(5 characters is usually all that is need) and sort on that you will have
control of how the data is sorted.

Regards.

Bill Ridgeway
Computer Solutions

"KB" wrote in message
...


"Gardien" wrote:

If I have a spreadsheet with company names, is there a way to have them
alphabetize themselves?