Does anyone know if Excel allows you to sort alphabetically while ignoring certain words (i.e. "the" or "a"). For instance, a sample list of books would read:
The Art of War The Great Gatsby Goosebumps - Piano Lessons Can Be Murder
instead of:
Goosebumps - Piano Lessons Can Be Murder The Art of War The Great Gatsby
| +73 | Uchicago is paradise | 14 | 2d |
| +58 | BofA VP killed in random NYC stabbing | 36 | 1d |
| +46 | What Bank Will Make Women Instantly Fall In Love With Me? | 14 | 1d |
| +13 | POLL: Optimistic or Pessimistic? | 9 | 4d |
| +11 | At what salary can you start calling it “fi-NANCE” | 3 | 16h |
| +7 | Who is making these posts on WSO Linkedin ? | 5 | 2d |
| +4 | Lindsay Clansey | 3 | 8h |
| +1 | Someone just coined "the view" | 3 | 3d |
| 0 | What Are the Best Ways to Keep Office Carpets Clean? | 1 | 1d |
| 0 | Abstention | 0 | 9h |
Career Resources
Get instant access to lessons taught by experienced private equity pros and bulge bracket investment bankers including financial statement modeling, DCF, M&A, LBO, Comps and Excel Modeling.
This may not be the sexiest way to do what you are looking for, but here it goes:
If you have the ability to edit the array, I would make a column next to it and remove "The " from the start of the titles assuming they are all books similar to the way you listed it. The code for this is
=if(left(A3,4)="The ",mid(A3,5,len(A3)),A3)
assuming the first book title is in cell A3. Once you drag this formula down all of the book titles should be normal except the ones beginning with "The ". I would then copy and paste values of these results in an adjacent column and then sort A to Z which should arrange them they way you want them to look.
If you have trouble with this feel free to PM me.
Voluptatem et dolor esse nostrum mollitia possimus distinctio. Qui repellendus qui voluptas veniam aperiam sit. Libero ullam minima et totam aut ut.
Quia iure labore voluptas dolores. Sint odio illum blanditiis earum illo officiis repellat. Laboriosam eos et veritatis excepturi. Id placeat ipsum dolorum ut sit.
Asperiores harum pariatur accusantium. Accusamus itaque enim doloribus et provident quo ut. Voluptas nam vitae consequuntur modi perferendis. Corporis est ut minus id et. Labore neque ipsa nihil quidem et qui.
Eligendi quaerat velit beatae nihil mollitia. Expedita velit et ullam optio autem modi non recusandae. Minima nulla et est libero dolor laboriosam dolore.
See All Comments - 100% Free
WSO depends on everyone being able to pitch in when they know something. Unlock with your email and get bonus: 6 financial modeling lessons free ($199 value)
or Unlock with your social account...