Forum Discussion
Solved
Excel Text Sorting
Is there a way to sort a column of text and ignore any leading "A" or "The" in the text? Thanks!
DarkPalidin , if you have the new dynamic array functions, this will work.
SergeiBaklan , nicely done. Quick question : How do you post the color coded formula on here? Also, do you format your fomulas like this in Excel. Looks very clean and easy to read.
