I have one excel spreed sheet, it have three worksheet,
they are sheet1, sheet2, sheet3, in each worksheets on
the column B has real long file directory, example:
J:\files\docfiles\amaya01\demand.mcp.wpd, all I need is
last file name: demand.mcp.wpd, it means I only need the
file name after the last slash "\", all the column B has
all the file name but in different directory, another
example:
j:\FILES\DOCFILES\Civil Service\CS-SUBIA\OLGA.SRP, all I
need is OLGA.SRP file name, so can we write the macro
removed everything before last slash "\".

SO this macro has be in the loop for sheet1,sheet2,sheet3.

thanks for the help.

Lillian