Hyperlinks using formula

[Formula11]

I wanted to create hyperlinks to open PDF files, based on the full filepath.

See example below.
Is there a way to turn this formula into a link that shows "Myfile.pdf" at the end ... in one step to prevent copy and paste, and then double clicking each cell to turn into a link ... without VBA.

="="&"HYPERLINK("&""""&I28&""""&","&""""&RIGHT(I28,MATCH("\",MID(I28,SEQUENCE(LEN(I28),,LEN(I28),-1),1),0)-1)&""""&")"

 

[bobsan42]

=HYPERLINK(I28,RIGHT(I28,MATCH("\",MID(I28,SEQUENCE(LEN(I28),,LEN(I28),-1),1),0)-1))

 

[Formula11]

Thanks bobsan42, this works, cheers

 

[Peter_SSs]

What about this simpler alternative?

=HYPERLINK(I28,TEXTAFTER(I28,"\",-1))

 

[Formula11]

Thanks Peter_SSs this works as well

 

[Peter_SSs]

You're welcome.