Extract text to left of numer

Hi there, I need some code that will extract the text ONLY from a string. The problem is the number in the string isn't stored as a number (as its part of a string).

Below are some examples

Lord Brantwood 3/1 (I need Lord Brantwood)
Running Wolf 120/1 (I need Running Wolf)
Majestic Sun 5/2 (I need Majestic Sun)

Thanks in advance

Will it always be 2 words that you want to extract? If so, try this:

Formula:

Please Login or Register  to view this content.

No, it could be 1 to 5 words

Well then just add a helper Column to calculate the number of words in the cell:

Formula:

Please Login or Register  to view this content.

Then, assuming the helper column is B1, you would update the formula to reference it as follows:

Formula:

Please Login or Register  to view this content.

Thats a great solution. Many thanks

Originally Posted by popipipo

Please Login or Register  to view this content.

Does this work?

No. the number still remains

Originally Posted by AlKey

Maybe this

=SUBSTITUTE(A1,MID(A1,MIN(SEARCH({0,1,2,3,4,5,6,7,8,9},A1&1234567890)),FIND("(",A1)-MIN(SEARCH({0,1,2,3,4,5,6,7,8,9},A1&1234567890))),"")

Row\Col	A	B
1	Lord Brantwood 3/1 (I need Lord Brantwood)	Lord Brantwood (I need Lord Brantwood)
2	Running Wolf 120/1 (I need Running Wolf)	Running Wolf (I need Running Wolf)
3	Majestic Sun 5/2 (I need Majestic Sun)	Majestic Sun (I need Majestic Sun)

That gives an error #VALUE!

Originally Posted by FDibbins

Hopefully someone else will come up with something more eligant, but this brute-force effort works without a helper...

Formula:

Please Login or Register  to view this content.

It works - but is too long to be entered as VBA code as part of a macro