Quick Excel Forumula Help!!!

[suarve]

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

 

[Malakite]

Either use the text to colums function and set it to delimited. if you set / as the delimter then it will split the text into a new cell every time it encounters /

either that or use formula Right(A1,10) This will bring back the rightmost 10 characters in the cell of your choice. However this only works if your filename is always image.xxx (a 3 letter extension)

If them file name can be a different size use

=RIGHT(C6,LEN(C6)-FIND("^^",SUBSTITUTE(C6,"/","^^",LEN(C6)-LEN(SUBSTITUTE(C6,"/","")))))

it will give you all the text to the right of the second /