Forum Discussion

Copper Contributor

Jul 04, 2020

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!

TheAntony
Jul 04, 2020
DarkPalidin , if you have the new dynamic array functions, this will work.
Sort removing A and The.xlsx11 KB

Iron Contributor

Jul 04, 2020

DarkPalidin , if you have the new dynamic array functions, this will work.

Sort removing A and The.xlsx11 KB

Copper Contributor

Jul 08, 2020

Exxcellent!, I can work with this.
duhg

Resources