I have a list of path names in column A and would like to extract the file names which come after the last "/" and before the last "." to be placed in column B. I also want all "%20" to be replaced with a space.
For example, cell A1 contains:
Level%202/SB/C10%20illus/SIF%20BC%20SB2B%20C10%20(I)%20aw%20code.docx?d=wae252c17551145c7b4b3b69c4d44f532&csf=1&e=hb3jX4
Cell B1 should have:
SIF BC SB2B C10 (I) aw code
Is there a formula I can put in column B?
Thanks in advance!
For example, cell A1 contains:
Level%202/SB/C10%20illus/SIF%20BC%20SB2B%20C10%20(I)%20aw%20code.docx?d=wae252c17551145c7b4b3b69c4d44f532&csf=1&e=hb3jX4
Cell B1 should have:
SIF BC SB2B C10 (I) aw code
Is there a formula I can put in column B?
Thanks in advance!