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?