Find Character in string (text) from Ending

The following formula will help you to identify specific character from the end.
For example, the character which want to find has multiple instances, this formulae will give you the last instance position.


If you want to extract what's to the right of the last forward slash you can
use

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

if you want the position

=FIND("^^",SUBSTITUTE(A1,"/","^^",LEN(A1)-LEN(SUBSTITUTE(A1,"/",""))))





No comments:

Post a Comment