| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
alphabetize ignoring hyphen
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? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Cell format - put hyphen where zero value would be. | New Users to Excel | |||
| Trying to use IF statement with hyphen | Excel Worksheet Functions | |||
| Optional hyphen? | Excel Discussion (Misc queries) | |||
| Copy Text to Right of Hyphen | Excel Discussion (Misc queries) | |||
| ...I want to display a hyphen instead of zero... | Excel Worksheet Functions | |||
Threaded Mode
