Formula to extract last 4 digits before .xlsm

[omairhe]

Hey everyone,

Hope all is fine. Here is a formula that would extract the first two digits of my filename

=MID(CELL("filename",A1),FIND("[",CELL("filename",A1))+1,2)

so if my filename is 01. January, 2020.xlsm this formula will extract 01

Well, this time I am looking for a formula that'd be able to extract last four digits from the same filename.

= 2020

will appreciate plenty.

thank you.

 

[tyija1995]

Hey,

With the filename in cell A1 try this in B1:
=LEFT(TRIM(RIGHT(SUBSTITUTE(A1," ",REPT(" ",LEN(A1))),LEN(A1))),FIND(".",TRIM(RIGHT(SUBSTITUTE(A1," ",REPT(" ",LEN(A1))),LEN(A1))))-1)

 

[Fluff]

How about
=MID(CELL("filename",A1),FIND(".xl",CELL("filename",A1))-4,4)