L
lewisweiss
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?
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?