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.
TheAntony , thank you
Here if replying on the post you use
you may select which language use for formatting
and it adds some colors to the formulas after you post the reply (not during replying).
In Excel - nope, I don't use any formatters. Just Alt+Enter in formula bar or copy/paste to Notepad++ to format relatively big formulas and after that copy/paste back.
SergeiBaklan , that's a neat feature. Thank you!
I'm learning a lot from your solutions. Thanks!