On Fri, 25 Jul 2008 00:01:01 -0700, lewisweiss
wrote:

i have a spreadsheet which i need to alphabetize. in column A are 4000
domain names. all of the domain names start with the word GLOBAL and then
another word. about 200 of them start with the word GLOBAL and then follow
with a hyphen before the word. i wish to alphabetize the entire spreadsheet
on the column A and IGNORE the hyphen so that the spreadsheet will be
alphabetized on column A by the word following the word GLOBAL. PLEASE HELP
HOW TO DO THIS? perhaps some macro formula can ignore the hyphen?

In a helper column, adjacent to your data, enter the formula:

=SUBSTITUTE(A1,"-","",1)

And fill down as far as required.

Sort on the helper column.

Then delete or hide the helper column.
--ron