Hi
have you tried the UDF?. It should return only this version number. At
least it worked for your example data?
If not what problems did you encounter (please post the example
filename in these cases)

--
Regards
Frank Kabel
Frankfurt, Germany


sorry if i was not clear in my earlier posting.

if you see the filenames that i have mentioned, there is a number
within the last 5-6 characters. thats the only number that keeps
changing (1, 2, 3, 4, 5, 6, 7) within all the filenames that i have
given. thats a sort of version number and thats what i am looking to
extract.

for example, in "ABC DEF123 IJK V7.xls", '7' is what i am looking to
extract. in "ABC_DEF123_IJK_V5.0.xls", '5' is what i am looking to
extract.

if the UDF extracts everything from the string, i might still have to
do some drudgery. some filenames are as long as 100 characters with
several numbers in them.

however, there is one condition that almost 95% of the strings would
adhere to. to the left of ".xls", if the first numeric character that
is greater than zero could be picked, that would be the number i am
looking for.

please help.


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