I want to use a formula to find substring from below string.
Economic Solution - 1
Economic Solution - 1
Economic Solution - 2
Economic Solution - 2
Economic Solution - 3
i want to get Economic Solution so i can group by.
length of Economic Solution can't use for substring.
but every string got only one -
So using postion of -
How to get substring using - ?