Lapas

piektdiena, 2015. gada 18. septembris

Excel revers find()

B1 - cell with string
~ - replace tilde(~) with other symbol if your string contains 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