| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sorting Spreadsheet Help
Try this:
=IF(OR(LEFT(A1,FIND(" ",A1&" ")-1)={"A","An","The"}),MID(A1,FIND(" ",A1&" ")+1,99),A1) "Lubslimegreen" wrote: I made a excel spreadsheet listing all the movies that I own. I'm wanting to put them in alphabetical order. I know how to sort by ascending and decending. My question is how do I sort so that A, AN, and THE are ignored. Thanks! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Problems sorting spreadsheet - Please Help | Excel Discussion (Misc queries) | |||
| Sorting in a Spreadsheet with Filter | Excel Worksheet Functions | |||
| Sorting the spreadsheet! | Excel Worksheet Functions | |||
| Trouble Sorting Spreadsheet | Excel Worksheet Functions | |||
| SORTING AN EXCEL SPREADSHEET ROW BY ROW | Excel Worksheet Functions | |||
Hybrid Mode
