icestationzbra wrote...
can you please tell me which is the latest formula or UDF that i
am supposed to be using

You're supposed to try them all and see what works best.

Actually, if you're going to use a UDF, then I should have mentioned
the Subst function. See the following link for its code.

http://www.google.com/groups?selm=7c...wsrange r.com

You could use it as

=subst(A1,".+[^._0-9][._]?(\d([._]\d+)?).*\.xls","$1")

to extract the version number from the filenames.

However, if you want to avoid UDFs (not a bad idea), looks like my last
formula works in a single cell as long as you're using standard US
settings.

=LOOKUP(99999,
ABS(-MID(SUBSTITUTE(LEFT(RIGHT(A1,9),5),"_",".",
1+MOD(ROW(INDIRECT("1:50")),2)),
6-MOD(INT((ROW(INDIRECT("1:50"))-1)/5),5),
1+MOD(ROW(INDIRECT("1:50"))-1,5))))


---
Message posted from http://www.ExcelForum.com/