How to extract a value from between brackets

[Oldie]

What a great site.
I've looked about here but haven't been able to find the answer although I'm sure it will be somewhere.
I have a value that is bracketed and I just want the number extracted to another cell. I've shown three part lines of the data I need to extract from.
Cd 56.5, (53.5), 1:34.16, (36.22),
53.0, (53.0), 1:36.32, (37.36), 6/1,
-2.0, (54.0), 1:59.26, (36.52), 9/1,
The values I need are 53.5 from line one-53.0 from line two & 54.0 from line three.
As you can see they don't always sit in the same column.
I'm a very basic Excel user so do be kind.
Can someone help me out please?

 

[Oldie]

Thank you all.
Krishnakumar, I reckon you have it.
That worked just fine.
I'm impressed.
To eveyone, a big thank you.

 

[barry houdini]

And Barry - yes, there are commas in the data.

back to the drawing board.....try

=SUBSTITUTE(INDEX(A1:E1,MATCH("(*)*",A1:E1,0)),",","")*-1

 

[Oldie]

Barry
You and I posted around the same time there before.
I'd just like to let you know, that formula worked too.
I'm pleased I was told of this site.
Just great.
Thanks.

 

[mtatum83]

Hi, welcome to the board!

It looks like you just want the first number in parentheses.

Perhaps:
=REPLACE(LEFT(A1,FIND(")",A1)-1),1,FIND("(",A1),"")

Copy down.

If you want it to actually be a number rather than a text string add a +0 to the end.

*	A	B
1	Cd 56.5, (53.5), 1:34.16, (36.22),	53.5
2	53.0, (53.0), 1:36.32, (37.36), 6/1,	53.0
3	-2.0, (54.0), 1:59.26, (36.52), 9/1,	54.0

<colgroup><col style="width: 30px; font-weight: bold;"><col style="width: 282px;"><col style="width: 64px;"></colgroup><tbody>
</tbody>

Spreadsheet Formulas

Cell Formula B1 =REPLACE(LEFT(A1,FIND(")",A1)-1),1,FIND("(",A1),"") B2 =REPLACE(LEFT(A2,FIND(")",A2)-1),1,FIND("(",A2),"") B3 =REPLACE(LEFT(A3,FIND(")",A3)-1),1,FIND("(",A3),"") <tbody> </tbody>

<tbody>
</tbody>

Excel tables to the web >> Excel Jeanie HTML 4

hi i know this is an old post but im panicing now, this formula looks close to what i need. here is the sheet:

	Sick
	Days	Hours	Date (Hours)
SEP		0.00	29(3), 31(2)
OCT		0.00
NOV		0.00
DEC		0.00
JAN		0.00
FEB		0.00
MAR		0.00
APR		0.00
MAY		0.00
JUN		0.00
JUL		0.00
AUG		0.00
Total:	0.00	#NAME?	What i need is to extract the numbers from all the brackets in the "date/hours" field and auto sum them, then put them in the "hours" field

<tbody>
</tbody><colgroup><col><col><col><col></colgroup>