FIND from the right not the left

[ruthhacche]

Looking to find the position of a character from the right hand end of a text string?

[TABLE="width: 1378"]
<tbody>[TR]
[TD="width: 1378"]K:\02. Photos\02.04 Product Photos\ARCHIVE\2015 Product Shots\KPE 2015\ANIMAL SKITTLES.jpg[/TD]
[/TR]
</tbody>[/TABLE]

So I want to find "" at position 20 or -20 rather than at 3

I am sure it must be simple but defying my small brain.

Thnaks

 

[steve the fish]

Hi. Try this:

=LEN(TRIM(RIGHT(SUBSTITUTE(A1,"\",REPT(" ",LEN(A1))),LEN(A1))))+1

 

[ruthhacche]

thank you steve the fish