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 :

Function RemovePath(MyPath) As String
RemovePath = Dir(MyPath)
End Function
to call it from a worksheet use a formula like :
=RemovePath("C:\TestDir\MyDocs\Test.xls")
to return Test.xls