Formula to extract text and numbers

[sobrien1234]

I have the names and numbers of greyhounds in column A and want a formula to extract the name and number in columns B and C.

For example:
A1 = Superior Merlot (Box 8)
A2 = Fatboy (Box 10)

So the answer to the formulas would be:
B1 = Superior Merlot
B2 = Fatboy

C1 = 8
C2= 10

Thanks in advance!

Seamus

 

[Peter_SSs]

I suggest that you update your Account details (click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

Try this

20 05 03.xlsm
	A	B	C
1	Superior Merlot (Box 8)	Superior Merlot	8
2	Fatboy (Box 10)	Fatboy	10
Greyhounds

Cell Formulas
Range	Formula
B1:B2	B1	=LEFT(A1,FIND("(",A1)-2)
C1:C2	C1	=SUBSTITUTE(REPLACE(A1,1,SEARCH("(Box",A1)+4,""),")","")+0

 

[sobrien1234]

tHA

I suggest that you update your Account details (click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

Try this

Thanks - that worked well but just realised there's number at the start as well!!!!!
For example:
9Superior Merlot (Box8)
10Fatboy (Box10)

So need to get rid of those numbers at the start of the text as well to get the same answers as you did before??

 

[Peter_SSs]

This is still true.

I suggest that you update your Account details (click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)