Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- =IF(ROW()-1=LEN($A$1)-LEN(SUBSTITUTE($A$1,"/","")),$A$1,LEFT($A$1,SEARCH(CHAR(36),SUBSTITUTE($A$1,"/",CHAR(36),ROW()))-2))
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement