Need Excel expert.

[kashif.special2005]

Hi,
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o> </o>
I wanted to extract number with version dynamically.
<o> </o>
Like YBR 5.11 Release Ans should be :- 5.11
TBA 4.x Version Ans should be :- 4.X
TKSTBA55.xwtVersion Ans should be :-55.xwt<o></o>

Thanks & Regards,
Kashif.

 

[Ruddles]

What's the exact rule for determining where the version number can be found?

 

[kashif.special2005]

Sorry, but I don't know maybe after point.

 

[Ruddles]

You're going to have to tell us what the rule is if you want us to produce the formula, otherwise we're just guessing. If you don't know your data, how can we know? (I wish there was a =MAYBE function in Excel!)

For example, the first two examples have spaces which we can use but the last one does not. Is that a typo?

Is the rule: "the third word"? Or "the first word which starts with a number"? Or "the word immediately before Release or Version"? Or "the first/last word with a dot in it"?

 

[jasonb75]

See my post in your duplicate thread

http://www.mrexcel.com/forum/showthread.php?t=552076