Extracting characters from call via Formula..

[omairhe]

Hey I would like to extract some characters from the cell B26 . I hope it is not much trouble..

B26 = C:\Users\User Name\Desktop\12-2020 (user.name).xlsm

I want to extract 2 characters that comes before "-" which is 12
Then I want to extract 4 characters that comes after "-" which is 2020
I would like to extract the filepath which is C:\Users\User Name\Desktop\

Will appreciate plenty and thanks.

Please note B26 is not consisting of any formula but the value is just giving a filename without the sheet name.
for instance using the code

Worksheets("HSheet").Range("B26") = ThisWorkbook.FullName

 

[Fluff]

If it will always be two characters before the - how about

+Fluff v2.xlsm
	B	C	D	E
26	C:\Users\User Name\Desktop\12-2020 (user.name).xlsm	12	2020	C:\Users\User Name\Desktop\
27
Main

Cell Formulas
Range	Formula
C26	C26	=MID(B26,FIND("-",B26)-2,2)
D26	D26	=MID(B26,FIND("-",B26)+1,4)
E26	E26	=REPLACE(B26,FIND("-",B26)-2,100,"")

 

[omairhe]

If it will always be two characters before the - how about

+Fluff v2.xlsm
	B	C	D	E
26	C:\Users\User Name\Desktop\12-2020 (user.name).xlsm	12	2020	C:\Users\User Name\Desktop\
27
Main

Cell Formulas
Range	Formula
C26	C26	=MID(B26,FIND("-",B26)-2,2)
D26	D26	=MID(B26,FIND("-",B26)+1,4)
E26	E26	=REPLACE(B26,FIND("-",B26)-2,100,"")

Thank you..

 

[Fluff]

You're welcome & thanks for the feedback.