Quick Excel Forumula Help!!!

Soldato
Joined
8 Oct 2005
Posts
4,184
Location
Midlands, UK
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
 
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 /
 
Last edited:
Back
Top Bottom