| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How do I sort a column alphabetically not consider "the" or "a"?
I would like to sort a worksheet alphabetically ascending, but certain row
has "The" or "A" at the beginning, so the rows with "The" at the beginning are arranged under "T" and the rows with "A" are categorized under "A". How do I eliminate this problem without deleting "The" or "A"? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Running total w/2 columns - Excel | Excel Worksheet Functions | |||
| match and count words | Excel Worksheet Functions | |||
| up to 7 functions? | Excel Worksheet Functions | |||
| How do I sort a column of formulas in Excel? | Excel Discussion (Misc queries) | |||
| How do I sort a column of formulas in Excel? | Excel Discussion (Misc queries) | |||
Threaded Mode
