Pathname - Delete everything before a /

Originally Posted by robert_harper

Hmm no worries I think I'll keep using replace button

If you want a formula try

=MID(A1,FIND("/",A1)+1,999)

Assumes only one / in string as per example

VBA Noob

Good morning robert_harper

You haven't really been that clear in what you want really - do you want to remove this from a sheet, within a macro? To do this effectively you need VBA, and this custom function should do what you need :

Please Login or Register  to view this content.

to call it from a worksheet use a formula like :
=RemovePath("C:\TestDir\MyDocs\Test.xls")
to return Test.xls