Extract number from text

[Avazquezd75]

Hello there, semi-noob-code-developer here !

I have being searching for an option to extract specific numbers from a string, and so far I have been unable to find a suitable solution.

I have this string format:
(14.370) FY14 - 3Q US Marketing Progression

I need to extract the 14.370 ... to be more accurate .. I need to extract the number AFTER the . BETWEEN the ( ) ... just the 370.

This has been a challenge, because since the string may change .. it always starts with the (number.number):

(11.1) TL Attainment Bonus
(13.19) WW GDFS/EI Program
(14.591): Services On Top Bonus

I hope this could be achieved ... Best regards !!

Andrew

 

[Rick Rothstein]

This will return the number as TEXT...

=MID(LEFT(A1,FIND(")",A1)-1),FIND(".",A1)+1,99)

and this will return it as a real number...

=0+MID(LEFT(A1,FIND(")",A1)-1),FIND(".",A1)+1,99)

 

[Avazquezd75]

Wow .... I just love when you found that what you saw as a "complex issue" required actually a really simple approach ......

I learned something new today...Thank you very much for your solution Rick ... Really appreciated !!

Andrew

 

[István Hirsch]

Another option:

=LOOKUP(10^10,1*MID(A1,FIND(".",A1)+1,{1,2,3,4,5,6,7,8,9,10}))