Skip to Content
0
Former Member
Mar 18, 2009 at 04:58 PM

Formula Question

8 Views

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 - ?