I have string like this -
D:\Project\Feature\branch\Main\Databases\XXX\XXX\XXX\XXX\XXX\XXX\XXX\sp_SampleSP.sql
Want to remove all text before "sp_SampleSP.sql". I have tried with Left formula in excel still not able to find solution.
I want output like this:sp_SampleSP.sql