excel - excelsheet query -

dadasdf\sdasdasd\qazxbbjj\test.txt

above string in cell a1 in excelsheet,i want extract last word cell.i.e,i want test.txt,how can acchive using excel function.if acchived declaring variable me out.

its clunky w/ formula can vba.

to module add;

function getfilename(cell range)   getfilename = mid(cell.value, 1 + instrrev(cell.value, "\")) end function 

then in cell can =getfilename(a1)