Alphabetizing text

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Barb - 13 Sep 2007 04:34 GMT

I am new to exel and have no clue as how to enter a formula or which one to
use. I want to put in a big directory with dept. names and their new
extensions. Then I want it alphabetized only. Any help would be appreciated
especialli in lame man terms.
Thanks,
Barb

Reply to this Message

Peo Sjoblom - 13 Sep 2007 04:38 GMT

It's easier if you have headers, then just select the whole range and do
data > sort and sort ascending by the dep names ( I assume)

Signature

Regards,

Peo Sjoblom

>I am new to exel and have no clue as how to enter a formula or which one to
> use. I want to put in a big directory with dept. names and their new
[quoted text clipped - 3 lines]
> Thanks,
> Barb

Reply to this Message

David McRitchie - 14 Sep 2007 05:43 GMT

Hi Barb,
If you are new to Excel, you are probably not aware of the potential
for destroying your data with a sort if you fail to select ALL cells first.
Before invoking the sort select all cells on the worksheet by
using Ctrl+A (3 times in Excel 2007, 2 times in Excel 2002).
Safest to use the Sort from the Data menu, and indicate there
whether you have headers or not (so you don't sort the headers as data).
http://www.mvps.org/dmcritchie/excel/sorting.htm
http://www.mvps.org/dmcritchie/excel/shortx2k.htm#foobar

Signature

HTH,
David McRitchie, Microsoft MVP -- Excel
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm

> It's easier if you have headers, then just select the whole range and do
> data > sort and sort ascending by the dep names ( I assume)
[quoted text clipped - 3 lines]
>> extensions. Then I want it alphabetized only. Any help would be
>> appreciated especially inlame man terms.

Reply to this Message

Rate this thread: