Find Image name from Excel Cell

Monday, 23 October 2017 17:15

Tim Ramsey

0 Comments

The formula below will give you the image name from a cell string

=SUBSTITUTE(REPLACE(A1,1,LOOKUP(2^15,FIND("/",A1,ROW(INDIRECT("1:"&LEN(A1))))),""),".jpg","")

1	=SUBSTITUTE(REPLACE(A1,1,LOOKUP(2^15,FIND("/",A1,ROW(INDIRECT("1:"&LEN(A1))))),""),".jpg","")

You must be logged in to post a comment.

Leave a Reply