How can I fix the following please. I'm getting a return because the formula is finding the "6th" in "26th" but that isn't what I want. I only wish to find "6th" for 6th, not the 6th in 16th, 26th, 36th etc.
Excel WorkbookGH2426th Battalion26th (Service) BattalionSheet1