Parse File Location
Thanks!
"JE McGimpsey" wrote:
One way:
=MID(A1, FIND("$$", SUBSTITUTE(A1, "\", "$$", LEN(A1) -
LEN(SUBSTITUTE(A1, "\", "")))) + 1, 255)
Where 255 is just a large number
In article ,
Mike wrote:
Hello,
I would like to parse the following to extract just the file name:
C:\MICTSeed\MICTSeeding.mdb.
The file name will be the same but the location can change so how do I
account for this when creatig my formula. Would it be better to do this using
VBA?
Thanks,
Mike
|