Haven't used excel in years so am well rusty 
Have a long list of data in column A exactly as follows:
small images/04 some folder/image.jpg
I need to get the file names in column B E.g. image.jpg (the extensions could vary).
Many Thanks
Have a long list of data in column A exactly as follows:
small images/04 some folder/image.jpg
I need to get the file names in column B E.g. image.jpg (the extensions could vary).
Many Thanks