Extract Version from text

[kashif.special2005]

Hi,
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o> </o>
I want to extract version from below mentioned texts
<o> </o>
A1 YBR 5.11 Release Answer:- 5.11<o></o>
A2 TBA 4.x Version Answer:- 4.x<o></o>
A3 YBR x.56 Version Answer:- x.56<o></o>
A4 4.1 Maestro Release Answer:- 4.1<o></o>
A5 YBR <?xml:namespace prefix = st1 ns = "urn:schemas-microsoft-comffice:smarttags" /><st1:City><st1lace>Mobile</st1lace></st1:City> 3.9 Release Answer:- 3.9
<o> </o>
Thanks & Regards,
Kashif.<o></o>

 

[jasonb75]

Not a guaranteed method if your format changes, but it works with your examples.

=TRIM(MID(SUBSTITUTE(A1," ",REPT(" ",10)),MAX(1,FIND(".",SUBSTITUTE(A1," ",REPT(" ",10)))-5),10))

 

[Peter_SSs]

Duplicate to http://www.mrexcel.com/forum/showthread.php?t=552002

Please do not post the same question multiple times. Questions of a duplicate nature will be locked or deleted, per the Posting Rules (especially points 21-23).

Any bumps, clarifications, or follow-ups should be posted back to the linked thread.