Extracting Number Inside parenthesis

[Max Alejandro Molina]

Hello Excel Nijas,

Anybody know how to get the green data with a formula,

Please see attached,

Thanks you!

 

[Somendra Misra]

Hi Max,

Try below formula in C3 and copy down:

=MID(B3,FIND("(",B3)+1,LEN(B3)-FIND("(",B3)-1)

Regards,

 

[Harshaler]

Hello Excel Nijas,

Anybody know how to get the green data with a formula,

Please see attached,

Thanks you!

Solution:

=MID(B3,FIND("(",B3)+1,FIND(")",B3)-FIND("(",B3)-1)

 

[Max Alejandro Molina]

Thanks! What if I wanted to get only the number outside the parenthesis?

 

[Hui]

=Left(B3,FIND("(",B3)-1)

 

[Somendra Misra]

Try =MID(B3,1,FIND(" (",B3))

Copy down.

Regards,

 

[Hui]

In the above solutions using Mid() and Left() the answer is being returned as a Text string. You will see that the result is left aligned, where as numbers are right aligned

Technically to convert it to a number you can either use a Value() function of perform some maths on it

eg:
=MID(B3,FIND("(",B3)+1,LEN(B3)-FIND("(",B3)-1)
Should be
=Value(MID(B3,FIND("(",B3)+1,LEN(B3)-FIND("(",B3)-1))
or
=- -MID(B3,FIND("(",B3)+1,LEN(B3)-FIND("(",B3)-1)

=Left(B3,FIND("(",B3)-1)
Should be
=Value(Left(B3,FIND("(",B3)-1))
or
=- - Left(B3,FIND("(",B3)-1)

 

[Somendra Misra]

@Hui

Didn't directly using the number in mathematical operation Like =1+Result will fetch the result.

Regards,

 

[Hui]

@Somendra,

Yes and No

In Excel, doing what you said works.

But I have seen examples used in say Open Office etc where the cells value is not picked up because it is text

 

[Somendra Misra]

Ohk....Thanks.

Regards,

 

[Max Alejandro Molina]

Thank you all very much!