Currently i have added the Formula(text) field in Results: column with formula = "SUBSTR({name}, LENGTH({name}), 1)"

Just Add it as Formula (text). It will sort on the first formal text of your results columns.