how to extract a filename?
a cell contains:
C:\Program Files\Amersham Biosciences\ImageMaster 2D Platinum
Trial\Gels\94-0005.mel
How to obtain 94-0005 in this case? certainly, the path can also be d: and
the filename is of any combinations of characters in general.
i find "FIND, MID, MATCH, RIGHT, ..." doesn't do a good job, thx!!
|