All issues related IT.
=IF(ISERROR(FIND("\",B1)),B1,RIGHT(B1,LEN(B1)-FIND("~",SUBSTITUTE(B1,"\","~",LEN(B1)-LEN(SUBSTITUTE(B1,"\",""))))))
Nav komentāru:
Ierakstīt komentāru