Can we sort by taking middle words in Excel? Example the different words are like this, Doc-Gen-001, Mat-Gen-007, Drw-Gen-010 i want to sort it by GEN, is this possible in Excel?
